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.
|lookp_values||It is the value to be found in the row|
|table_array||It is the range of table|
|row_index_num||It is the row number in table array from which the matching value will be returned|
|range_lookup||It 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.|
|row_index_num||2 which is SALARY column number|
|range_lookup||Here value must be FALSE because I want to perform EXACT MATCH.|
When you run the above formula, you will get “40000” as an answer.
That’s all done.