Formula Library
MATCH
lookupReturns the relative position of a value within an array or range.
Syntax
=MATCH(lookup_value, lookup_array, [match_type])Example
Excel
=MATCH("Apple", A:A, 0)Returns the row number (position) where "Apple" is found in column A.
Tips & Notes
- →Use 0 for exact match, 1 for less than, -1 for greater than
- →Often used with INDEX
- →Returns #N/A if not found
See Also
Need a custom MATCH formula?
Describe exactly what you need and get the formula generated instantly.