IntermediateLookup & Reference
Look up a customer's region with XLOOKUP
Match a customer ID against a reference table to return their region.
XLOOKUP
8 min25 points
What is Excel telling you with #N/A?
The situation
A lookup column has come back full of #N/A and the first instinct on the team is to wrap everything in IFERROR to tidy the report. It is worth knowing what the error is reporting before deciding to hide it.
Who this is for
Recommended next
Related exercises
- AdvancedLookup & Reference
Handle missing lookups gracefully
Return a readable message instead of #N/A when a lookup finds nothing.
XLOOKUP
10 min40 points - AdvancedData Cleaning
Reconcile a list with hidden spaces
Match two lists where one side has trailing spaces you cannot see.
COUNTIF · IF
12 min35 points - IntermediateLookup & Reference
Look up a customer's region with XLOOKUP
Match a customer ID against a reference table to return their region.
XLOOKUP
8 min25 points