Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
INDEX and MATCH. MATCH(value, list, 0) gives the position of a value in a list: 1 for the first cell, 2 for the second. INDEX(range, n) returns the nth cell of a range. Used together, both ranges must start on the same row.
=INDEX(C2:C9,MATCH("Oslo",A2:A9,0)) C on the row where A is OsloThe AI pulled unit prices from the price list with INDEX and MATCH. The line totals look off, and one of them is an error.
AI assistant: “I used INDEX/MATCH with an exact match to fill each line’s unit price in C2:C9.”
Fix C2:C9 so every unit price matches the price list in G1:H7.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product ID | Qty | Unit price | Line total | Product ID | List price | ||
| 2 | 302 | 6 | 16.5AI | 99 | 103 | 59 | ||
| 3 | 103 | 3 | List priceAI | #VALUE! | 202 | 16.5 | ||
| 4 | 404 | 13 | 17.5AI | 227.5 | 302 | 17.5 | ||
| 5 | 202 | 12 | 59AI | 708 | 404 | 13.5 | ||
| 6 | 303 | 2 | 12.5AI | 25 | 106 | 12.5 | ||
| 7 | 106 | 12 | 13.5AI | 162 | 303 | 25 | ||
| 8 | 302 | 2 | 16.5AI | 33 | ||||
| 9 | 202 | 4 | 59AI | 236 | ||||
| 10 | ||||||||
| 11 | ||||||||
| 12 |
=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