|Connect us with


HLOOKUP in Excel - With Example

What is Hlookup In Excel | Hlookup Syntax | How to Use Hlookup | Example | Explanation

HLOOKUP function is used to retrieve the values from one row to another row correspondingly. it means it lookup the values horizontally. in HLOOKUP H stands for Horizontal, and hence it is also called as Horizontal Lookup. we already discussed the VLOOKUP Function in our Excel Tutorials.

Use HLOOKUP when your comparison values are located in a row across the top of a table of data and you want to look down a specified number of rows.

Note:-Before starting any Formula or Function you need to add (=)

Syntax of Excel HLOOKUP:

Below is The Syntax of HLOOKUP function in Excel.

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

How to Use HLOOKUP in Excel?

Let's understand how to use HLOOKUP in Excel with Example.

In this example, we have two workbooks with State-wise Target, Archived, Status Etc. data. in the Hlookup1 workbook only heading are there without any values. but in the Hlookup2 workbook, we have headings with values.

How To Use Hlookup Function in Excel

Hlookup1 Workbook

How To Use Hlookup Function in Excel

Hlookup2 Workbook

Now the task is, we need to get values from the Hlookup1 workbook to the Hlookup2 workbook with row headings correspondingly.

Result:

In this Example to get the result, we used the Hlookup formula in Excel is
=HLOOKUP(C1,[Hlookup1.xlsx]Sheet1!$B$1:$F$2,2,0)

How To Use Hlookup Function in Excel

HLOOKUP Example Explanation:

1. The first argument 'lookup_value'="B1" (Cell where you want to get the value).

2. Second argument 'table_array'="[Hlookup1.xlsx]Sheet1!$B$1:$F$2" (Hlookup1.xlsx workbook Data Range).

3. Third argument 'row_index_num'=2 (the row number to be returned).

4. Fourth argument 'range_lookup'=0 or FALSE (Required only Exact Match).

The difference between VLOOKUP in Excel and HLOOKUP in Excel is, instead of column index number we are using a row index number.

After watching the video you can download below sample sheet. and it helps you to do practice more. please subscribe for more videos on our youtube channel. if you like our tutorial please share it on Facebook and Youtube below.


To Get FREE Excel Shortcut Keys
       



Previous

Next



YOUR COMMENTS ARE MOST IMPORTANT TO US:

0 Comments



Why basictutorials.in ?

● To Learn Tutorials in a Simple Way.

● To Learn Excel Basics With Downloadable Samples.

● To Learn HTML With Sample Website Code.

● To Learn PowerPoint Presentations.

● To Learn MS Word for Offical use.