HLOOKUP function


DESCRIPTION:

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

 

SYNTAX:

=HLOOKUP( lookup_value, table_array, row_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.