VLOOKUP: find a product price
Lesson 5 of 5In cell E2, write a formula that finds the Price of the product named in D2, using the table in A1:B6.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product | Price | Look up | Price | |
| 2 | Notebook | 3.5 | Stapler | ||
| 3 | Pen | 1.25 | |||
| 4 | Stapler | 8.99 | |||
| 5 | Folder | 2.1 | |||
| 6 | Marker | 1.75 |
Type in the formula bar above and press Enter to check.