How to use HLOOKUP Function (Formula) In Excel

HLOOKUP

Use of HLOOKUP Function (Formula) In Excel

In HLOOKUP "H" stand for "Horizontal lookup".

Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify.

Syntax/Formula of HLOOKUP Function in Excel

The syntax of HLOOKUP function in Microsoft Excel is below

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

Example of HLOOKUP Function in Excel

In below example we need total marks of all student in cell A3 to K3. . 

So in this case we use HLOOKUP function to get all students total marks.

In both table unique value is Student Roll No so its our lookup value,

table_array is Second table location is A6:K11,

row_index_num is no of rows in second table is 6, and

range_lookup is 0 or False for exact match. or you can use 1 or True for approximate match.

I recommend please use 0 or False it give you accurate result.

Step 1: First create below "Table 1" in cell location A1:K3 and "Table 2" in cell location A6:K11

Step 2: Type formula =HLOOKUP(B1,6:11,6,0) in cell B3 and press enter.

Step 3: Copy HLOOKUP formula from cell B3 and pest it in to cell range C3 to K3.

HLOOKUP FUNCTION