HLOOKUP function

HLOOKUP searches for a value and reference to the cells under the selected area. This function verifies if the first row of an array contains a certain value. The function returns the value in a row of the array, which is named in the index, in the same column.


HLOOKUP(search_criteria, array, index, sorted)


You want to enter the number of an item on a food menu in cell A1, and have the name of the item be displayed immediately as text in the neighboring cell (B1). The Number to Name assignment is contained in the A4:AZ5 array.
Note: AZ represents column number 52.

A4 contains 52, A5 contains the name "Vegetable Soup," and so on, for 52 menu items.

Enter the following formula in B1:

=HLOOKUP(A1, A4:AZ5, 2)

After you enter a number in A1, B1 shows the corresponding text contained in the second row of reference A4:AZ5. Entering a nonexistent number causes the text to be displayed with the next number down. If you want a nonexistent number to generate an error message instead, enter FALSE as the last parameter in the formula.

Trademarks | IBM Connections wiki