When using HLOOKUP, the most common questions focus on errors, result checking, and filling formulas across cells; this FAQ includes 3 common questions and a 3-term glossary.
FAQ
What should I do if HLOOKUP returns an error value?
- Check whether the number and order of parameters are correct.
- Confirm that the first row of the selected range contains the value you want to search for.
- Make sure the return row number does not exceed the number of rows in the selected range.
- If you need an exact match, verify that the match setting is appropriate for the current data.
Why does the HLOOKUP result not match what I expected?
- Check whether the lookup value and the first-row data use the same format, such as text versus number.
- Confirm that the selected range is correct and includes both the top row and the target return row.
- If you are using approximate match, make sure the first row is arranged appropriately for that lookup mode.
- Review the references in the formula bar and switch to absolute references if needed.
How do I apply HLOOKUP to multiple cells?
- Enter and confirm the HLOOKUP formula in the first target cell.
- Select that cell and move the pointer to the fill handle in the lower-right corner.
- Drag the fill handle down or across to copy the formula to other target cells.
- After filling, check whether the range references should be fixed with
$.
Glossary
| Term | Definition |
|---|---|
| HLOOKUP | A horizontal lookup function that searches for a specified value in the first row of a range and returns the result from a specified row in the same column. |
| Lookup range | The data range used by HLOOKUP for matching and returning results. Its first row is used to search for the lookup value. |
| Return row number | The row position inside the selected lookup range from which the result is returned. The first row is counted as 1. |