Excel Function

HLOOKUP

Looks up a value in first row and returns matching value.

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

Arguments

lookup_value

Required

Enter the value you want to look up.

table_array

Required

Specify the full table range used for lookup.

row_index_num

Required

Enter the return row number in table_array (1-based).

range_lookup

Optional

Set lookup behavior. FALSE = exact match, TRUE/omitted = approximate match (lookup range must be sorted ascending).

Practice Preview

Use HLOOKUP to search the first row of columns A to D horizontally for the value in cell B2 (項目B in column B) and return the value from row 2. You can set ranges by dragging from the start cell to the end cell in the same argument field.

Example Table

#	A項目A	B項目B	C項目C	D項目D
2	Product Name	Price	Stock	Category
3	Apple	120	80	Food
4	Banana	98	120	Food
5
6
7
8

How to Use (Formula)

=HLOOKUP(B2, A2:D4, 2, FALSE)

Result

120

Practice This Function

Start Function Practice Back to Function List

HLOOKUP FAQ

How do I use HLOOKUP in Excel?

Use HLOOKUP when you want to look up values across a horizontal table. Enter Lookup value, Table array, Row number in that order, then add optional arguments when needed.

Where can I practice HLOOKUP?

Use the "Start Function Practice" button to jump straight into HLOOKUP drills.

What arguments does HLOOKUP use?

The main arguments are Lookup value, Table array, Row number, Lookup mode. Start with the required ones, then add optional arguments if needed.