Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
MATCH
MATCH returns the position — not the value — of a lookup within a range. It is most powerful paired with INDEX, but on its own it tells you which row or column a value sits in.
Excel
=MATCH(D2, A:A, 0)Google Sheets
=MATCH(D2, A:A, 0)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1D2 is the value to find.
- 2A:A is the range to search.
- 30 forces an exact match and returns the position.