HLOOKUP
Searches first row and returns matching value.
- Excel: Verified match
- Google Sheets: Verified match
- Returns: Any value
Examples
=HLOOKUP("beta", W1:Y2, 2, FALSE) | W | X | Y | |
|---|---|---|---|
| 1 | alpha | beta | gamma |
| 2 | 1 | 2 | 3 |
Result 2
Syntax
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])lookup_value- any required
table_array- range required
row_index_num- number required
range_lookup- boolean optional defaults to
1
Related
ADDRESSReturns a cell address as text from row and column numbers. AREASReturns the number of areas in a reference. HYPERLINKThe text a link displays: clickability is the renderer's. INDEXReturns value at row and column in range. INDIRECTReturns reference specified by text string. LOOKUPLooks up value in one-row or one-column range.