Task 1 of 3
In D2:D5, check whether the codes in A and B match, including case.
Lesson theory
SWITCH(value, option1, result1, …, [default])replaces a long chain of IFs when you compare against exact values;EXACT(text1, text2)compares case-sensitively. The usual=A2=B2ignores case;IFNA(value, fallback)works like IFERROR but catches only#N/A. Other errors stay visible, so you will not miss them;XOR(cond1, cond2)is TRUE when exactly one condition is true (for two conditions).
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.