Sheets ExercisesFree · Lesson 15: Lookup project
0 pts
✕
0
Step 1 of 4

Wrap a lookup with IFERROR

In G2, look up O-403 in A2:D7 and return its rep from column 4. Wrap the VLOOKUP in IFERROR with Not found as the fallback.

Show formula shape
=IFERROR(VLOOKUP(key, table, column, FALSE), "fallback")
100%
G2fx
A
B
C
D
E
F
G
H
I
1
Order
Priority
Amount
Rep
Project result
2
O-401
Urgent
180
Ana
Rep for O-403
3
O-402
Routine
75
Bo
Rep for O-999
4
O-403
Urgent
220
Cam
5
O-404
Urgent
90
Ana
Urgent total
6
O-405
Routine
140
Dee
Urgent Cam total
7
O-406
Urgent
160
Cam
8
9
10
11
12
13
Order desk
G2