Excel HLOOKUP Formula Maker

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

Enter the value to search for in the first row. Can be:
  • A cell reference (e.g., A1)
  • Text (e.g., "Product")
  • Number (e.g., 100)
Enter the range containing your data (e.g., A1:D10). The lookup value must be in the first row of this range.
Enter the row number from which to return the value (e.g., 2 for second row). Must be less than or equal to the number of rows in your table array.
Returns closest match if exact match not found. First row must be sorted in ascending order.
Returns #N/A if exact match not found. First row doesn't need to be sorted.
Generated Formula:

Examples of HLOOKUP Function

Scenario Formula Result
Find the price of "Mango" =HLOOKUP("Mango", A1:D3, 2, FALSE) 120
What is stock of "Orange" =HLOOKUP("Orange", A1:D3, 3, FALSE) 40
Price of "Banana" =HLOOKUP("Banana", A1:D3, 2, FALSE) 80
Search the stock of "Apple" =HLOOKUP("Apple", A1:D3, 3, FALSE) 50
Find the price of "Grapes" (not in table, will return error) =HLOOKUP("Grapes", A1:D3, 2, FALSE) #N/A
Price of a product mentioned in cell F1 =HLOOKUP(F1, A1:D3, 2, FALSE) 120
Find the price of "Orange" using a dynamic reference =HLOOKUP(A5, A1:D3, 2, FALSE) If A5 = "Orange", Result: 90