Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
You are matching CRM contacts to Brightline’s customer list in E1:F9. Some refs in column B came in with spaces around them, so a plain lookup can’t find them.
In C2:C7, return the customer name from F2:F9 for the ref in column B. Clean the ref inside the formula, so the import in column B stays untouched.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Contact | Ref (import) | Customer | Ref | Customer | |||
| 2 | Maria Hart | C-1053 | C-1010 | Oak Labs | ||||
| 3 | Kevin Garcia | C-1065 | C-1017 | Cedar Realty | ||||
| 4 | Olivia Hughes | C-1069 | C-1053 | Meadow Clinic | ||||
| 5 | Julia Stone | C-1017 | C-1061 | Willow Consulting | ||||
| 6 | Elena Dimitrov | C-1061 | C-1065 | Granite Clinic | ||||
| 7 | Paul Baker | C-1092 | C-1069 | Maple Academy | ||||
| 8 | C-1076 | Pioneer Consulting | ||||||
| 9 | C-1092 | Summit Realty | ||||||
| 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