Excel VLOOKUP Function

 

 

 

Summary 

VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.

Purpose 

Lookup a value in a table by matching on the first column

 

Return value 

The matched value from a table.

 

Syntax 

=VLOOKUP (value, table, col_index, [range_lookup])

 

Arguments 

• value - The value to look for in the first column of a table.
• table - The table from which to retrieve a value.
• col_index - The column in the table from which to retrieve a value.
• range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.