Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud
Try in the cloud

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.

VLOOKUP Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action