Excel HLOOKUP Function

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.

• Using the Excel HLOOKUP Function
• Excel HLOOKUP Example
• HLOOKUP Function Syntax
• HLOOKUP Error Messages