Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
You're a customer-success analyst merging two contact lists from different CRMs. Each row pairs a customer name from CRM 1 (column A) with a name from CRM 2 (column B). The two CRMs were maintained independently and have different normalization conventions: case differs (Acme Corp vs acme corp), whitespace differs (trailing spaces, leading spaces), and some pairs are genuinely different companies that just look similar.
Your task — for each row, decide whether the two names refer to the same company after normalizing for case and whitespace. Output "Match" if they're the same company, "No Match" if they're different.
The grader compares the literal string output, so the cell value must be exactly "Match" or "No Match".
Recommended approach — multi-step normalization with LET:
=LET(a, LOWER(TRIM(A2)), b, LOWER(TRIM(B2)), IF(a=b, "Match", "No Match"))
LOWER folds case; TRIM strips leading/trailing whitespace and collapses internal runs; LET binds the normalized forms once per side; IF compares.
Watch for false matches — "Initech" and "Initek" differ by one letter (typo, not normalization). And false near-misses — "Pied Piper" vs "Pied Piper Inc" differ by suffix and aren't the same company per the dedup rule.
Graded cells: C3 (Globex / GLOBEX → Match), C6 (Pied Piper / Pied Piper Inc → No Match), C10 (Wayne Enterprises / wayne enterprises → Match).