← Back to level 2
Level 2Next
HLOOKUP
A medium lookup formula for reading values across the top row of a table and returning a lower row.
Syntax
=HLOOKUP(...)Step-by-step explanation
- 1Find the value you want to look up and the table that contains the answer.
- 2Point the formula at the lookup range and the return range or position.
- 3Press Enter and confirm that Excel returns the matching record.
Common mistakes
Using it on vertical tables
Counting the wrong row number
Forgetting exact match settings
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=HLOOKUP(A1:B2)
Result
68
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =HLOOKUP(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 68.
Practice area
Use HLOOKUP when your lookup labels run horizontally instead of vertically.
Match against the syntax block above.