VLOOKUP Formula

VLOOKUP formula performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position.

Syntax of VLOOKUP formula:

VLOOKUP( value, table_array, col_index_number, [range_lookup] )

Parameters Details:

value: The value to search for in the first column of the table.
table_array: Two or more columns of data that is sorted in ascending order.
col_index_number: The column number in table from which the matching value must be returned. The first column is 1.
range_lookup: Optional. Enter FALSE to find an exact match. Enter TRUE to find an approximate match. If this parameter is omitted, TRUE is the default.

Returns

The VLOOKUP function returns any datatype such as a string, numeric, date, etc.
If you specify FALSE for the approximate_match parameter and no exact match is found, then the VLOOKUP function will return #N/A.
If you specify TRUE for the approximate_match parameter and no exact match is found, then the next smaller value is returned.
If index_number is less than 1, the VLOOKUP function will return #VALUE!.
If index_number is greater than the number of columns in table, the VLOOKUP function will return #REF!.

VLOOKUP Formula Example
VLOOKUP Formula Example