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