Lookup & Referenceintermediate
Look up a value across a row with HLOOKUP
=HLOOKUP(B1,$B$1:$F$5,3,FALSE)
Function reference
HLOOKUP in Excel & Google Sheets
HLOOKUP is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.
1 intermediateBuild a custom HLOOKUP formula →
When to use HLOOKUP
- Look up a product code in a header row and return the matching price, budget, or quantity from a specific row in a horizontal table layout.
Worked examples (1)
Common errors with HLOOKUP
#N/A error
The lookup value was not found in the first row. Check for extra spaces, case mismatches, or confirm the value actually exists in the header row.
Wrong row returned
The row index counts from 1 (the header row). If you want the third data row, the index should be 4, not 3, because the header is row 1.
Frequently asked questions
When should I use HLOOKUP instead of INDEX/MATCH?
HLOOKUP is simpler for straightforward horizontal lookups. INDEX/MATCH is more flexible when the header row position may change or when you need a two-way lookup.
Need a custom variation?
Describe your specific HLOOKUP problem and get a formula written for your exact data.
Open generator with HLOOKUP