Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Reading #N/A. #N/A means a lookup didn’t find what it searched for. Check three things: is the value really in the list, is the formula searching the column that holds that kind of value, and is the match exact? A whole column of #N/A usually means the formula searches the wrong place.
=XLOOKUP(A2,K2:K20,L2:L20) K must hold the same kind of value as A2
You asked the AI assistant to put customer names next to February’s orders using the customer list in F1:G9. Every row came back #N/A.
AI assistant: “I used XLOOKUP in C2:C9 to bring in each customer’s name from the list in F1:G9.”
Fix C2:C9 so each order shows its customer’s name from F1:G9.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Customer ID | Customer | Customer ID | Customer name | |||
| 2 | 50094 | 1069 | #N/AAI | 1001 | Harbor & Pine Hotels | |||
| 3 | 50095 | 1015 | #N/AAI | 1004 | River Print Co | |||
| 4 | 50096 | 1029 | #N/AAI | 1013 | Orchard Academy | |||
| 5 | 50097 | 1013 | #N/AAI | 1015 | River Bakery | |||
| 6 | 50098 | 1075 | #N/AAI | 1029 | Orchard Print Co | |||
| 7 | 50099 | 1004 | #N/AAI | 1069 | Maple Academy | |||
| 8 | 51106 | 1001 | #N/AAI | 1071 | Atlas Bakery | |||
| 9 | 50100 | 1071 | #N/AAI | 1075 | Lakeside Pharmacy | |||
| 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