Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Looking up to the left. VLOOKUP can only return a column to the right of the one it searches. When the key sits to the right of the answer, use XLOOKUP, which takes the search range and the answer range separately, or INDEX with MATCH.
=INDEX(B2:B30,MATCH(F2,D2:D30,0)) the name in B, found by the code in D
The warehouse system exports its product list with the product ID in the last column (H). The September pick list needs product names next to each ID.
In C2:C11, look up the product name (column F) for each product ID in column A, using the list in F1:H25.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product ID | Qty | Product name | Product name | Category | Product ID | ||
| 2 | 105 | 6 | Copy Paper A4 (500) | Paper & Print | 101 | |||
| 3 | 406 | 5 | Recycled Paper A4 (500) | Paper & Print | 102 | |||
| 4 | 201 | 4 | Toner Cartridge Black | Paper & Print | 103 | |||
| 5 | 203 | 13 | Toner Cartridge Color | Paper & Print | 104 | |||
| 6 | 104 | 2 | Label Roll (1000) | Paper & Print | 105 | |||
| 7 | 303 | 1 | Envelope Box (250) | Paper & Print | 106 | |||
| 8 | 404 | 5 | Espresso Beans 1kg | Coffee & Kitchen | 201 | |||
| 9 | 201 | 12 | Filter Coffee 1kg | Coffee & Kitchen | 202 | |||
| 10 | 306 | 12 | Paper Cups (1000) | Coffee & Kitchen | 203 | |||
| 11 | 205 | 30 | Tea Assortment (200) | Coffee & Kitchen | 204 | |||
| 12 | Oat Milk 12-pack | Coffee & Kitchen | 205 | |||||
| 13 | Sugar Sticks (1000) | Coffee & Kitchen | 206 | |||||
| 14 | All-Purpose Cleaner 5L | Cleaning | 301 | |||||
| 15 | Hand Soap Refill 5L | Cleaning | 302 | |||||
| 16 | Paper Towels (24) | Cleaning | 303 | |||||
| 17 | Trash Bags (200) | Cleaning | 304 | |||||
| 18 | Disinfectant Wipes (12) | Cleaning | 305 | |||||
| 19 | Microfiber Cloths (50) | Cleaning | 306 | |||||
| 20 | Ballpoint Pens (50) | Desk Supplies | 401 | |||||
| 21 | Sticky Notes (24) | Desk Supplies | 402 | |||||
| 22 | Stapler Heavy Duty | Desk Supplies | 403 | |||||
| 23 | Whiteboard Markers (12) | Desk Supplies | 404 | |||||
| 24 | Desk Organizer | Desk Supplies | 405 | |||||
| 25 | Notebook A5 (10) | Desk Supplies | 406 | |||||
| 26 | ||||||||
| 27 | ||||||||
| 28 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe