Level 2LookupsPractice, 2 min
VLOOKUP a price
The task
A customer ordered the SKU in E2. In F2, look up its price from the price list with
VLOOKUP. Price is the 3rd column of A:C, and you want an exact match.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | SKU | Product | Price | Order SKU | Price | |
| 2 | SKU-101 | Notebook | $4.50 | SKU-104 | ||
| 3 | SKU-102 | Pens (10 pack) | $7.25 | |||
| 4 | SKU-103 | Stapler | $12.00 | |||
| 5 | SKU-104 | Packing tape | $3.80 | |||
| 6 | SKU-105 | File folders | $6.00 |