Challenge: clean a list, then match it
75%
PROPERTRIMXLOOKUPVLOOKUP
This is the most common real task in the whole course: two lists that should agree and do not, because one of them was typed by humans.
Clean in one column, match in the next. Keeping the two steps apart means that when something does not match you can see immediately which step is at fault, and when the next export arrives you only have to check the cleaning.
In B2, clean the raw name. In C2, look the cleaned name up in E2:F5 and return the account. Fill both down to row 5.
The grid for this exercise is part of the paid half.
Everything above is yours to read either way. 46 exercises stay free with a profile.