HLOOKUP
Looks in the top row of an array and returns the value of the indicated cell.
Lookup & ReferenceLookup & Matching Essentials
What it does
Searches for a value in the top row of a table and returns a value in the same column from a row you specify.
Syntax
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Arguments
lookup_value(value) — Value to find in the first row.table_array(range) — Table range.row_index_num(number) — Row number to retrieve.
Examples
Horizontal Lookup
Find value for 'Q2' in row 2.
FORMULA
=HLOOKUP("Q2", A1:C2, 2, FALSE)RESULT
200
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Q1 | Q2 | Q3 |
| 2 | 100 | 200 | 300 |