Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000. The second argument is the range of cells, C2-:E7, in which to search for the value you want to find. The third argument is the column in that range of cells that contains the value that you seek.
Look up values in a list of data - Microsoft Support
Look up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned.
VLOOKUP function - Microsoft Support
Use the VLOOKUP function to look up a value in a table. There are four pieces of information that you will need in order to build the VLOOKUP syntax: The value you want to look up, also called the lookup value. The range where the lookup value is located.
Excel functions that return ranges or arrays - Microsoft Support
Below is a list of functions that could return multi-cell ranges or arrays in what we refer to as pre-dynamic array Excel. If these functions were used in workbooks predating dynamic arrays, and returned a multi-cell range or array to the grid (or a function that did not expect them), then silent implicit intersection would have occurred.
MATCH function - Microsoft Support
How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
INDEX function - Microsoft Support
Returns the value of an element in a table or an array, selected by the row and column number indexes. Use the array form if the first argument to INDEX is an array constant. INDEX (array, row_num, [column_num]) The array form of the INDEX function has the following arguments: array Required. A range of cells or an array constant.
FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define. In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").
Overview of formulas in Excel - Microsoft Support
A reference identifies a cell or a range of cells on a worksheet, and tells Excel where to look for the values or data you want to use in a formula. You can use references to use data contained in different parts of a worksheet in one formula or use the value from one cell in several formulas.
Count how often a value occurs - Microsoft Support
Use the COUNTIF function to count how many times a particular value appears in a range of cells. The COUNTIFS function is similar to the function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of …
How to correct a #REF! error - Microsoft Support
In the following example, =VLOOKUP(A8,A2:D5,5,FALSE) will return a #REF! error because it’s looking for a value to return from column 5, but the reference range is A:D, which is only 4 columns. Solution. Adjust the range to be larger or reduce the column lookup value to match the reference range.