Free practice · Hands-on spreadsheet · hard
Practice
Look up a product price
In F2, use an exact VLOOKUP to return the unit price for the product code in E2 from A2:C5.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | ||||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 |
Free practice · Hands-on spreadsheet · hard
Look up a product price
In F2, use an exact VLOOKUP to return the unit price for the product code in E2 from A2:C5.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | ||||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 |