top of page

HLOOKUP FUNCTION

HLOOKUP is an Excel function that enables searching for a value in a table or range by comparing it with data within a row. It functions similarly to the well-known VLOOKUP, but with a distinction: while VLOOKUP searches vertically within columns, HLOOKUP performs horizontal searches within rows.

HLOOKUP proves particularly beneficial when data is structured horizontally, where the lookup values are located in the first row and the corresponding data is found in rows below.

The syntax of the function is: 

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

  • lookup_value – The value you are searching for, which can be text, number, or a cell reference.

  • table_array – The range where you will perform the lookup. The range must start with the row containing the lookup value and should include the row from which you want to return the result.

  • row_index_num – The row number from which you want to return the result. The number should be relative to the first row in the selected range in table_array.

Next
bottom of page