XMATCH
Searches for a specified item in an array or range of cells, and then returns the item's relative position
Syntax
XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])
Parameters
- lookup_value: Required. The lookup value
- lookup_array: Required. The array or range to search
- match_mode: Optional. 0=exact match (default), -1=exact or next smaller, 1=exact or next larger, 2=wildcard match
- search_mode: Optional. 1=first-to-last (default), -1=last-to-first, 2=binary ascending, -2=binary descending
Example
=XMATCH("Smith", A:A)