What is MATCH?
Returns the relative position of an item in an array. Commonly paired with INDEX for powerful two-way lookups that surpass VLOOKUP's limitations.
Syntax
=MATCH(lookup_value, lookup_array, [match_type])
Example
Formula: =MATCH(\
Result: 5
How It Works
Searches for 'Orange' in range A1:A10 and returns its position (5 if found in A5). Match_type 0 means exact match, 1 means less than or equal, -1 means greater than or equal.