Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. 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. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.

The H in HLOOKUP stands for “Horizontal.”

Please follow the below steps:-

Hlookup Syntax

HLOOKUP (Lookup-value, table array, row-index-number, (range-lookup))

Explanation of Hlookup Syntax.

There are four pieces of information that you will need to perform Hlookup Syntax:-

Lookup Value:– What value do you want to look at in the sheet? Select the same. the same value is called the lookup value.

Note- If you want to look any text as a lookup value please write it like this “Gold”.

For example, if you want Gold as your lookup value then the syntax should be like =Hlookup(“Gold”,table_array, row_index_num, [range_lookup])

Table_array:– Select the range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for Hlookup to work correctly.

Row_index_num:- Select the column number which you want to return. For example, if you specify 3:8 as the range you should count row 3 as the first row.

(Row 3=1

Row 4 =2

Row 5=3………….)

Note:-The row number counts start from the selected row.

Range_lookup:- It’s the Range of the lookup table.

True: Approximate match

False: – Exact Match

You May Also Like

By admin

Leave a Reply

Your email address will not be published.