Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
IFNA. IFNA(value, value_if_na) returns value, unless it is the #N/A error a failed lookup gives; then it returns your fallback. Unlike IFERROR it lets other errors through, so a typo in the formula still shows up instead of being hidden.
=IFNA(VLOOKUP(A2,H2:I9,2,FALSE),"Unknown")
Some CRM contacts point at customer refs that don’t exist in Brightline’s customer list (E1:F9), probably test records. A plain lookup shows #N/A for them, which breaks the report.
In C2:C9, return the customer name from F2:F9 for the ref in column B. When the ref isn’t in the list, show the text No customer instead of #N/A.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Contact | Ref | Customer | Ref | Customer | |||
| 2 | Sam Ward | C-1150 | C-1030 | Copper Labs | ||||
| 3 | Paul Price | C-1113 | C-1036 | Copper Media | ||||
| 4 | Nina Silva | C-0999 | C-1099 | Blue Accounting | ||||
| 5 | Rachel Lopez | C-1099 | C-1113 | Bright Hotels | ||||
| 6 | John Garcia | C-1030 | C-1117 | Oak Hotels | ||||
| 7 | Sam Smith | C-1134 | C-1118 | Harbor Law Group | ||||
| 8 | Maria Moreno | C-1121 | C-1119 | Granite Hotels | ||||
| 9 | Leo Walsh | C-1036 | C-1120 | Willow 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