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.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.