Common LOOKUP questions usually involve errors, unexpected results, and filling formulas across cells; this FAQ includes 3 common questions and a 3-term glossary.
FAQ
What should I do if LOOKUP returns a #VALUE! error?
- Check whether the parameter data types are consistent, and avoid mixing text with numbers.
- Check whether the cell content contains extra spaces or hidden characters.
- Clean the data and confirm the formula again.
Why does the LOOKUP result not match what I expect?
- Check whether the referenced ranges are correct and whether the lookup range matches the result range by position.
- Check whether the related cells use the correct data type.
- Review each parameter in the formula and reselect the range if needed.
How can I use LOOKUP in multiple cells at once?
- Enter and confirm the LOOKUP formula in the first target cell.
- Select that cell, then drag the fill handle across the target area, or copy and paste the formula into other cells.
- Check whether relative and absolute references behave as expected, and use $ when you need to lock a reference.
Glossary
| Term | Definition |
|---|---|
| LOOKUP | A lookup function that searches a specified range and returns a result from the corresponding position. |
| Lookup range | The single row, single column, or array area used to search for the target value. |
| Return range | The row or column that provides the returned result for the matched position. |