Look up a value in the top row of a range and return a value from another row in the same column.
Syntax
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])Arguments
lookup_valuerequired
The value to find in the first row.
table_arrayrequired
The range that contains the data.
row_index_numrequired
The row number in the range to return the value from.
range_lookupoptional
FALSE for exact match, TRUE for approximate.
HLOOKUP (Horizontal Lookup) is the row-wise twin of VLOOKUP: it searches the first row of a table and returns a value from a row you specify. Use it when your data is laid out in rows rather than columns. Set the last argument to FALSE for an exact match.
=HLOOKUP("Q3", A1:E4, 3, FALSE)→$58,000Finds the Q3 column and returns the value from the 3rd row.
Confirm a row layout
Use HLOOKUP only when headers run across the top row.
Count the return row
Identify which row holds the answer, counting from the top.
Lock to exact match
End with FALSE to avoid approximate hits.
XLOOKUP handles both row and column lookups and is more robust. Use HLOOKUP mainly for compatibility with older sheets.