HLOOKUP() function

Functions Jun 04, 2019

About  HLOOKUP() function

The HLOOKUP() function is a lookup and reference function that stands for horizontal lookup that returns the piece of information for the lookup value matches in the database that is in horizontal form. It keeps 4 parameters and they are lookup_value, table_array, row_index_num and range_lookup.

Where to apply :

This function helps in getting data from master table and to map the data.

Syntax :

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

Parameters :

lookup_value - A value that is used for matching data in the table to

table_array - A table or a range.

row_index_num - row number of the table array.

[range_lookup] - True of False. FALSE for exact match and TRUE for approximate match.

Excel based example:

Lets take a table to understand the use of HLOOKUP() function.

Image 1 - Table1

1. Here we need to find name for the codes mentioned below.

Image 2 - Codes

Formula that we apply to retrieve name against code.

Image 3 - HLOOKUP() function

The HLOOKUP() function is well explained in above image.

Hope, it would have added in your Excel function knowledge.

Thank You!

Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.

If you want to learn Excel & VBA courses to be Excel expert, connect us on:

9599408486 / 8929231250
Website: https://www.excelhour.in/

Manoj kumar

Corporate Trainer at ExcelHour. I have devoted over 9 years to various industries for learning multiple data challenges and trained Excel and VBA courses to the corporate along with offline training.

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.