Lookup & Reference
Deprecated
HLOOKUP
Searches the top row of a range and returns a value from the same column.
Available in All versions
Syntax
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])What it returns
The value from the chosen row, in the matched column.
Arguments
| Argument | Required | Description |
|---|---|---|
lookup_value |
Yes | The value to look up in the top row. |
table_array |
Yes | The table in which to search. |
row_index_num |
Yes | The row number from which to return the value. |
range_lookup |
No | TRUE/1 approximate (default), FALSE/0 exact match. |
Example
Lookup value
Q1
| A | B | |
|---|---|---|
| 1 | Quarter | Sales |
| 2 | Q1 | 500 |
| 3 | Q2 | 620 |
| 4 | Q3 | 480 |
Result
500
HLOOKUP searches along a row — shown here as the find → return relationship.
=HLOOKUP("Q1", A1:E3, 2, FALSE)Important to know
With TRUE/1, the top row must be sorted ascending, or results are wrong.
Use FALSE/0 for exact lookups.