Excel HLOOKUP Error Messages
- If the lookup_value is not found in the first row of the table_array, HLOOKUP returns the #N/A error value.
- If the row_index_num argument is greater than the number of rows in table_array, HLOOKUP returns the #REF! error value.
- If the table_array argument includes empty rows at the top of the table_array, HLOOKUP returns the #N/A error value.
