ExcelHeroThe INDEX function
Returns the value at a position in a range.
How to write it
=INDEX(array, row_num, [column_num])- array
- The range.
- row_num
- Which position (row).
- column_num
- Optional. Which column in a table.
💡 Pair it with MATCH to look up in any direction.
Try it
What is the 4th score in the list?
A
B
C
D
1
Student
Score
Result
2
Aisha
88
3
Ben
54
4
Chloe
97
5
Dev
71
6
Emma
63
7
Finn
79
=INDEX(range, position).