Free practice
You just read about VLOOKUP. Now type one.
Three VLOOKUP questions, right here in the page. Type your formula, press Check, and you find out right away. No sign-up needed.
Question 1 of 3
Try it yourself
In G2, write a VLOOKUP that returns the Price for the ID typed in F2.
A
B
C
D
E
F
G
H
I
J
K
1
2
3
4
5
6
7
8
Product ID
Product Name
Price
Stock
Search
Result
SKU-101
Magnifying Glass
$24.99
150
SKU-104
SKU-102
Forensic Chemistry Set
$45.00
75
SKU-101
SKU-103
Pocket Watch
$35.00
200
SKU-105
SKU-104
Field Binoculars
$65.00
50
SKU-102
SKU-105
Cipher Decoder
$28.50
120
SKU-103
Still working through the theory? The VLOOKUP guide covers the same ground in writing.