VLOOKUP function


DESCRIPTION:

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

 

SYNTAX:

=VLOOKUP( lookup_value, table_array, col_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.