Look up a value across a row instead of down a column.
Copy this formula
=HLOOKUP(A2, Table, 2, FALSE)HLOOKUP searches the top row of a table for a value and returns a result from a row below it. Use FALSE for an exact match. It's the horizontal counterpart to VLOOKUP; XLOOKUP can do both.
=HLOOKUP("Q2", A1:E5, 3, FALSE)→8,400Returns row 3's value under the Q2 column.
XLOOKUP (any direction)
=XLOOKUP(A2, A1:E1, A3:E3)Looks across a row and returns from another row.
Use HLOOKUP when your data runs left-to-right in rows, VLOOKUP when it runs top-to-bottom in columns.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.