HLOOKUP function

description:

Look up a value in a table by matching on the first row.

 

syntax:

=HLOOKUP( lookup_valuetable_arrayrow_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.
row_index_num The column in the table from which to retrieve a value.

 

optional arguments:

[range_lookup] Type of match.