Excel HLOOKUP Error Messages
The following error messages are associated with HLOOKUP.#N/A error :
- This error is displayed if the lookup value is not found in the first column of the table array.
- It will also be displayed if the range for the table array argument is inaccurate. If this argument includes empty rows above the table array.
- This error is displayed if the row index number argument is greater than the number of rows in table array. In the image above, the #REF! error occurs because the row index number is set to 3 while there are only two rows in the Table_array.
This completes the tutorial on creating and using the HLOOKUP function in Excel 2007.Return to the Index page