MS-Excel / Excel 2003

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:


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.

[Previous] [Contents] [Next]