Arguments
lookup_value- The value whose position you want.lookup_array- The range to search.match_type(optional) - 0 exact (recommended), 1 largest ≤ value, -1 smallest ≥ value.
MATCH
Returns the position of a value within a range, rather than the value itself.
Syntax
=MATCH(lookup_value, lookup_array, [match_type])=MATCH(A2, C2:C100, 0)Returns: The row number where C equals A2
Exact match returns a position you can feed into INDEX.
Common Errors and Gotchas
- #N/A means the value isn't in the array (or match_type isn't 0 on unsorted data).
- MATCH returns a relative position, not a cell reference - wrap it in INDEX to get the value.
Does MATCH Work in Google Sheets?
Yes. MATCH uses the same syntax in Google Sheets and LibreOffice Calc, so you can paste these formulas straight across.
Build a MATCH formula
Fill in your ranges and copy a ready-to-paste formula - no signup.