Sheets ExercisesFree · Lesson 11: VLOOKUP
0 pts
✕
0
Step 1 of 4

Find an exact price

In G2, find the SKU in F2 within A2:D5. Return the price from column 3 and use FALSE for an exact match.

Show formula shape
=VLOOKUP(search key, table, column index, FALSE)
100%
G2fx
A
B
C
D
E
F
G
H
1
SKU
Product
Price
Supplier
Search SKU
Result
2
P-103
Folder
4
Atlas
P-104
3
P-101
Notebook
6
Nova
P-101
4
P-104
Marker
3
Bright
P-102
5
P-102
Pen
2
Nova
P-102
6
7
8
9
10
11
Product list
G2