Excel Function

MATCH

Returns relative position of lookup value in a range.

MATCH(lookup_value, lookup_array, [match_type])

Arguments

lookup_value

Required

Enter the value you want to look up.

lookup_array

Required

Specify the row/column range where the lookup key is searched.

match_type

Optional

Set MATCH behavior: 0 = exact, 1/omitted = largest value less than or equal (ascending), -1 = smallest value greater than or equal (descending).

Practice Preview

find the position of a lookup key. Use MATCH to Returns relative position of lookup value in a range. 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 0 for match_type. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=MATCH(B2, B2:B8, 0)

Practice This Function

Practice in Sequential Mode Back to Function List