Look up a value in the top row of a range and return a value from another row in the same column.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])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)Result: $58,000
Finds the Q3 column and returns the value from the 3rd row.
XLOOKUP handles both row and column lookups and is more robust. Use HLOOKUP mainly for compatibility with older sheets.