MATCH
Lookup & referenceExcel 2007Return the position of a value within a row or column.
Syntax
MATCH(lookup_value, lookup_array, [match_type])
Arguments
- lookup_value
- What to find.
- lookup_array
- A single row or column to search.
- match_typeoptional
- 0 exact (use this), 1 largest ≤ value (array sorted asc), -1 smallest ≥ value (sorted desc).
Examples
=MATCH("Blue", A2:A20, 0)
→ 7
=INDEX(price, MATCH(A2, code, 0))
→
Related functions
More Lookup & reference functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.