FUNCTION CATALOGUE / LOOKUP & REFERENCE
XMATCH Excel function
Returns the position of a matching item.
Correct sentence to use
Find the position of [lookup value] in [range].
Modify this query in PlainFormula →Example formula
=XMATCH(E2,A:A)
Returns the relative position of a match.
Syntax
XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])
Argument signature: lookup_value, lookup_array, [match_mode], [search_mode]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.