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

show matching details by a header value. Use HLOOKUP to Looks up a value in first row and returns matching value. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. For lookup_value, enter the value to search and set the related reference ranges. use 2 for row_index_num, use FALSE for range_lookup. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=HLOOKUP(B2, B2:D5, 2, FALSE)

Practice This Function

Practice in Sequential Mode Back to Function List