Sheets ExercisesFree · Lesson 13: INDEX and MATCH
0 pts
✕
0
Step 1 of 4

Find a position

In G2, use MATCH to find the exact position of F2 within A2:A5.

Show formula shape
=MATCH(search key, range, 0)
100%
G2fx
A
B
C
D
E
F
G
H
1
Employee
Team
Shift
Search
Result
2
Ana
Operations
Morning
Cam
3
Bo
Sales
Evening
3
4
Cam
Finance
Morning
Dee
5
Dee
Support
Evening
Bo
6
7
8
9
10
11
Team roster
G2