Exercises / Lookups · 1 of 10
Look up a product price
VLOOKUP searches the first column of a table for a value, then returns a value from another column in the same row.
Your taskIn F2, use VLOOKUP to find the price of the product code in E2, using the table in A2:C7. Ask for an exact match.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Code | Product | Price | Code | Price | |
| 2 | P-101 | Notebook | $3.50 | P-104 | ||
| 3 | P-102 | Pen set | $6.00 | |||
| 4 | P-103 | Stapler | $12.90 | |||
| 5 | P-104 | Desk lamp | $24.00 | |||
| 6 | P-105 | Backpack | $39.99 | |||
| 7 | P-106 | Monitor arm | $58.00 |