Map Inconsistent Customer Names to Stable IDs in Excel and Google Sheets
Build a reviewed alias crosswalk in Excel or Google Sheets that maps inconsistent customer spellings to stable customer IDs with an exact-match XLOOKUP and an explicit UNMAPPED NAME flag. Walk through an 8-invoice test across Google Sheets and Excel for the web, plus a reconciliation check block that catches raw-name splits, approximate-lookup misroutes, blank IFERROR omissions, and table resizes.


