admin

02 April 2018

1 Comment

Home MS Office Excel

Use of HLookup in Excel

Today, Let’s learn about HLookup function in Excel. Most of the people are confused in these functions. They think that this formula is hard to use. In the corporate world, HLookup formula is very useful.

Usage: The HLOOKUP function can be used to find an exact match in the lookup row.

Syntax

=HLOOKUP(lookup_values,table_array,row_index_num,range_lookup)

PropertyUsage
lookp_valuesIt is the value to be found in the row
table_arrayIt is the range of table
row_index_numIt is the row number in table array from which the matching value will be returned
range_lookupIt is a local value. To find the closest match in the top row.Value can be True for Approximate Match and False for Exact Match.

Let’s understand this function with an example. I have 5 employees data as below:
 ABCDEF
1EmployeeNameRohitPrincyKartikKrishnaHrishik
2Salary1000020000300004000050000

From the table, I want to get the salary of Krishna. To achieve this, the values for HLOOKUP() will be as below:
PropertyValues
lookp_valuesKrishna
table_arrayA1:F2
row_index_num2 which is SALARY column number
range_lookupHere value must be FALSE because I want to perform EXACT MATCH.

Let’s feed given values to the formula. So final formula will be as below:

=HLOOKUP(“Krishna”,A1:F2,2,FALSE)

When you run the above formula, you will get “40000” as an answer.

That’s all done.

Author: admin

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *