VLOOKUP function

description:

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

 

syntax:

=VLOOKUP( lookup_valuetable_arraycol_index_num[range_lookup] )

 

required arguments:

lookup_value The value to look for in the first column of a table.
table_array The table from which to retrieve a value.
col_index_num The column in the table from which to retrieve a value.

 

optional arguments:

[range_lookup] Type of match.