ExcelHeroThe MATCH function
Returns the position of a value in a range.
In German Excel: VERGLEICH
How to write it
=MATCH(lookup_value, lookup_array, [match_type])- lookup_value
- What to find.
- lookup_array
- Where to find it.
- match_type
- 0 for an exact match.
💡 MATCH gives a number, not the value: feed it to INDEX.
Try it
At which position is the student in C2?
A
B
C
D
1
Student
Score
Find
Result
2
Aisha
88
Chloe
3
Ben
54
4
Chloe
97
5
Dev
71
6
Emma
63
7
Finn
79
=MATCH(what, where, 0). 0 means exact.