Course
VLOOKUP practice exercises
Ten exercises, from your first VLOOKUP to a price and stock grid built with MATCH. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 10
Find a product’s price
In F2, write a VLOOKUP that returns the price of the code in E2, using the table in A1:C9.
| Code | Product | Price ($) | Code | Price ($) | |
| P-101 | Wireless mouse | 24.90 | P-104 | ||
| P-102 | USB-C cable | 9.50 | |||
| P-103 | Keyboard | 49.00 | |||
| P-104 | 24" monitor | 189.00 | |||
| P-105 | Laptop stand | 35.00 | |||
| P-106 | HD webcam | 59.90 | |||
| P-107 | Headset | 79.00 | |||
| P-108 | Desk lamp | 32.50 |