Performing a horizontal lookup
The horizontal lookup function is called HLOOKUP. The HLOOKUP function searches horizontally (left to right) the topmost row of a lookup table until it locates a value that matches or exceeds the one that you're looking up. The HLOOKUP function not only works very much like the VLOOKUP but also follows a nearly identical syntax:
HLOOKUP(lookup_value,table_array,rowindex_num,[range_lookup])
The row_index_num argument in the HLOOKUP function is the number of the row whose values are compared to the lookup_value in a horizontal table. This argument must also be greater than zero and not exceed the total number of rows in the table.
In this tutorial:
More from MS-Excel