What is the use of HLOOKUP function in Excel?

The Excel HLOOKUP function finds and retrieve a value from data in a horizontal table. The “H” in HLOOKUP stands for “horizontal”, and lookup values must appear in the first row of the table, moving horizontally to the right. HLOOKUP supports approximate and exact matching, and wildcards (* ?) for finding partial matches.

  • Purpose: Look up a value in a table arranged horizontally
  • Return value: The matched value from a table.


=HLOOKUP (lookup_value, table_array, row_index, [range_lookup])


  • lookup_value - The value to look up.
  • table_array - The table from which to retrieve data.
  • row_index - The row number from which to retrieve data.
  • range_lookup - [optional] A Boolean to indicate exact match or approximate match. Default = TRUE = approximate match.