Table_array is the table of two or more columns of data. Col_index_num is the column number in table_array from which the matching value must be returned. Range_lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match. CIVL 1112 Excel - Lookup Functions 1/5.
Explanation: the VLOOKUP function looks for the ID (104) in the leftmost column of the range $E$4:$G$7 and returns the value in the same row from the third column (third argument is set to 3). The fourth argument is set to FALSE to return an exact match or a #N/A error if not found.
Drag the VLOOKUP function in cell B2 down to cell B11. Note: when we drag the VLOOKUP function down, the ($E$4:$G$7) stays the same, while the relative reference (A2) changes to A3, A4, A5, etc. Visit our page about the function for much more information and many examples.
Hlookup In a similar way, you can use the HLOOKUP (Horizontal lookup) function. Match The MATCH function returns the position of a value in a given range.
Explanation: Yellow found at position 3 in the range E4:E7. The third argument is optional. Set this argument to 0 to return the position of the value that is exactly equal to lookupvalue (A2) or a #N/A error if not found. Use and become an Excel pro. Index The INDEX function below returns a specific value in a two-dimensional range. Explanation: 92 found at the intersection of row 3 and column 2 in the range E4:F7.
The INDEX function below returns a specific value in a one-dimensional range. Explanation: 97 found at position 3 in the range E4:E7.
Use and become an Excel pro. Choose The CHOOSE function returns a value from a list of values, based on a position number. Explanation: Boat found at position 3.