Excel Function

XMATCH

Enhanced MATCH with additional matching/search options.

XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

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_mode

Optional

XMATCH/XLOOKUP match mode: 0 = exact, -1 = exact or next smaller, 1 = exact or next larger, 2 = wildcard match.

search_mode

Optional

XMATCH/XLOOKUP search mode: 1 = first-to-last, -1 = last-to-first, 2 = binary ascending, -2 = binary descending.

Practice Preview

find a lookup position with flexible match modes. Use XMATCH to Enhanced MATCH with additional matching/search options. 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_mode, use 1 for search_mode. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=XMATCH(B2, B2:B8, 0, 1)

Practice This Function

Practice in Sequential Mode Back to Function List