 ## HLOOKUP in Excel:

In the HLOOKUP Function “H” stand for horizontal and with the help of this formula, we can retrieve the matched value from the selected cells(table array) from up to down means in horizontal order. It supports approximate and exact matched value. It can only look up and retrieve the values in the horizontal order. The lookup value must be in the first row in the selected cells(table array).

### Need for HLOOKUP formula: –

• With the help of HLOOKUP, we can retrieve the numbers of exact or approximate matched value in the seconds.
• It helps in saving time and doing work more efficiently.
• it will show the matched value in the column/row where you want. So, we don’t need to find the values individually from the selected date and then copy, paste it.

### The Feature of HLOOKUP formula: –

1. It works only up to down. It can only look up the value from the Selected cell(Table_array) from up to the downside. it means from the rows.
2. This formula provides two types of matched value i.e. approximate and exact.
3. HLOOKUP always finds the first matched value from the selected cell(Table_array) and retrieve it.
4. We can use 1 and 0 instead of Ture and False respectively.
5. It retrieves data based on the Row number.

### Explanation of Formula:-

Now, We will explain the Arguments of the formula.

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

lookup_value: –  The lookup value is that value, which will find the exact matched value from the selected cells with this formula. This value is always written in the first row of the selected cells(table array) because HLOOKUP only finds the value in the horizontal order from the selected cells(table array).

table_array: – This is the array of selected cells from which the HLOOKUP will find and retrieve the matched value.

row_index_num: – It means Row Index Number. The number of that row from which we want to retrieve the matched value. The number of rows is counted from the first row of the selected cells(table array).

range_lookup: – It means what type of match you want to show. There is two types of match shown as following: –

1. Ture: – Approximate Match
2. False: – Exact Match

If you want to retrieve the Exact match value to show, then write the false and if you approximate matched value, then write true.

### Example of Formula: –

In the following table, we want to retrieve the predetermined percentage of increment from the table according to the appraisal score.

Solution:-

We will use the VLOOKUP formula to retrieve the predetermine the percentage of increment according to the appraisal score.

1st Step: –

We will write the “=HLOOKUP( ” in the column of the percentage of increment.

2nd Step: –

Select the value which we common in both table i.e. Appraisal Score and add a comma at the end.

3rd Step: –

Select the Table array from which we want to retrieve the value and add a comma at the end.

4th Step: –

Fix the selection of table array by adding the dollar sign (\$) in both the starting and end of the selection like shown below: –

This step is needed where we did not want to update the selection of the table array when we copy the whole formula in the remaining cell.

5th Step: –

Now select the number of the column of the selected table array of which the value you want to retrieve.

6th Step:

Now choose the mode of matching if you want to match exact value then enter false or 0 or if you want to match approximate value then enter true or 1.

Now, press enter key, the formula is complete and you will get the result.

Step No. 7: –

So copy this result(means formula) and then paste it in the remaining cell in which you want to use the same.

Thanks

Also, Check out the following function of excel: –

1. #### How to use VLOOKUP in Excel - free explanation

January 26, 2021

[…] HLOOKUP in Excel – Explanation with example […]

2. #### IF Function in Excel - Free Explanation with example - Xplore Excel

January 26, 2021

[…] How to use HLOOKUP in Excel – free explanation […]

3. #### Excel SUMIF Function - Download practice Sheet - Xplore Excel

January 26, 2021

[…] How to use HLOOKUP in Excel – free explanation  […]

4. #### Excel Match Function- Download 2 practice Sheet - Xplore Excel

January 26, 2021

[…] How to use HLOOKUP in Excel – free explanation  […]

5. #### COUNT Function in Excel- Download 2 Practice Sheet - Xplore Excel

January 26, 2021

[…] How to use HLOOKUP in Excel – free explanation  […]

6. #### COUNTIF Excel Function - Download 2 Practice Sheets - Xplore Excel

January 26, 2021

[…] How to use HLOOKUP in Excel – free explanation  […]

7. #### Sum Function in Excel - Download 2 Practice Sheets - Xplore Excel

January 26, 2021

[…] How to use HLOOKUP in Excel – free explanation  […]

8. #### zortilonrel

January 26, 2021

The heart of your writing while appearing reasonable at first, did not work properly with me personally after some time. Someplace within the paragraphs you actually were able to make me a believer unfortunately only for a short while. I however have got a problem with your jumps in logic and you might do nicely to help fill in all those gaps. In the event you actually can accomplish that, I could undoubtedly end up being fascinated.

January 26, 2021

[…] How to use HLOOKUP in Excel – free explanation  […]

10. #### zovrelioptor

January 26, 2021

I will right away take hold of your rss as I can not to find your email subscription hyperlink or newsletter service. Do you have any? Kindly permit me know in order that I could subscribe. Thanks.

11. #### IFERROR Excel Function- Free 2 Practice workbooks

January 26, 2021

[…] How to use HLOOKUP in Excel – free explanation  […]

12. #### IFNA Excel Function | Free 2 Practice workbooks - Xplore Excel

January 26, 2021

[…] Function in Excel with other Excel Formulas and Functions Like, IFNA with VLOOKUP and IFNA with HLOOKUP. So let’s […]