VLOOKUP Function
The VLOOKUP function is one of the lookup and reference functions. It is used to perform the vertical search for a value in the left-most column of a table or an array and return the value in the same row based on a specified column index number.
Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
The VLOOKUP function has the following arguments:
Argument |
Description |
lookup_value |
A value to search for. |
table_array |
Two or more columns containing data sorted in ascending order. |
col_index_num |
A column number in the table_array, a numeric value greater than or equal to 1 but less than the number of columns in the table_array. |
range_lookup |
A logical value TRUE or FALSE. It is an optional argument. Enter FALSE to find an exact match. Enter TRUE or omit this argument to find an approximate match, in this case if there is not a value that strictly matches the lookup_value, then the function will choose the next largest value less than the lookup_value. |
Notes
If the range_lookup is set to FALSE, but no exact match is found, then the function will return the #N/A error.
How to apply the VLOOKUP function.
Examples
The figure below displays the result returned by the VLOOKUP function.
Return to previous page