Excel Functions

Excel XMATCH Function

Pinterest LinkedIn Tumblr

The XMATCH function executes lookup and returns a position in vertical or horizontal ranges, it searches for a specified item in an array or range of cells and then returns the item’s relative position. XMATCH supports approximate and exact matching, reverse search, and wildcards (* ?) for partial matches. 

Purpose of Excel XMATCH Function

Searches for a specified item in an array or range of cells.

Return value

Returns the relative position of the specified.


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


Lookup ValueRefer a value to be looked upMandatory
Lookup ArrayArray or Range to searchMandatory
Match Mode0 = exact match (default), -1 = exact match or next smallest, 1 = exact match or next larger, 2 = wildcard match.Optional
Search Mode1 = search from first (default), -1 = search from last, 2 = binary search ascending, -2 = binary search descending.Optional

Usage notes

  • XMATCH can perform lookups in vertical or horizontal ranges, and is meant to be a more flexible and powerful successor to the MATCH function.


Microsoft 365

Related Posts

Write A Comment