Standardising Categories with a Mapping Table (XLOOKUP)
This lesson is part of the course
In this lesson
You map 14 free-text expense labels to four standard categories, catch the labels the mapping does not know yet, and total by category.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Trimming Spaces & Fixing Case: TRIM, PROPER, UPPER Locked
- Splitting Codes & Names: LEFT, MID, FIND Locked
- Converting Text Numbers & Text Dates into Real Values Locked
- Standardising Categories with a Mapping Table (XLOOKUP) Locked
- Finding Duplicates & First Occurrences with COUNTIFS Locked
- Handling Blanks & Outliers: IF, MEDIAN and Flags Locked
- Validating Rows: Rule Checks with AND, OR and an Error Count Locked
- Capstone: an Analysis-Ready Table and a Region × Month Summary Locked