Excel Hlookup Formula

Learn How to use Excel Hlookup Formula:

In Excel HLOOKUP formula, H stands for Horizontal and LOOKUP means lookup. Hlookup is used to lookup values in a data table where lookup_value resides. Lets see Hlookup syntax and an example to understand how it works.

Hlookup Syntax: Hlookup(lookup_value, table_array, row_index_num, [range_lookup])

Lookup_Value: It is the value to search for in the Table _Array (Data table). Lookup value should be in first row of the data table.
Table_Array: It is the data table where lookup_value is in the first row.
Row_Index_Num: Row Index Number is the row number in Table_Array that has the information you want to return.
Range_Lookup: It could be either True (1) or False (0). True or 1 is applied when you want an appropriate match. False or 0 is applied when you are looking for an exact match.

Example on Excel HLOOKUP Formula:

Below is the database of Quarter wise Product Sales from where we have to search for Quarter Sales mentioned in cell B13. As of now it is Qtr 3.

Excel HLookup Formula

Example HLookup Formula

Lets find out Quarter 3 Total Sales in above case with the help of Excel Hlookup Formula.

Lookup_Value: Cell B13 is the lookup_value beacuase we are searching for more information on employee code mentioned in cell B13.
Table_Array: Range C3:F9 in the data table is where we have to search for more information on Quarter Number mentioned in cell B13 (in our case it is Qtr 3). It is important to note that Quarter Number should be there in first row of Table_Array/Data table.
Row_Index_Num: Row Index Number is the row number in Table_Array that has the information you want to return. In the above case, we want to return Total Sales that resides in Row no. 7 of Data Table. Make a note that we have to consider row number of Data Table (Table_Array) and not row number of the sheet.
Range_Lookup: It is 0 (or False) because we have to go for exact match.

Please refer to below screen in case you want to use Hlookup with the help of Function Argument.

Excel Hlookup Formula

Example: Hlookup Function Argument

Hope you may find this useful.

You may also consider learning Excel Vlookup Formula that is a sister formula of Hlookup.


Categories: Formulas

Tags: ,

Leave a Reply

%d bloggers like this: