HLOOKUP
Searches the top row of a table, and returns from a row you choose by number.
How it’s written
HLOOKUP(find, table, row_number, FALSE)Example
| A | B | C | |
|---|---|---|---|
| 1 | Q1 | Q2 | Q3 |
| 2 | 100 | 200 | 300 |
=HLOOKUP("Q2",A1:C2,2,FALSE)Result: 200
Finds Q2 in the top row, and returns the value below it.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Use it when your headers run across the top. XLOOKUP handles this too.
Practice it properly
VLOOKUP and INDEX/MATCH gives you real tasks, with your formulas tested on data you haven’t seen.