I have 2 tables. Table 1 is the main table but the name's are messy. I would like to use Table 2 to map in the Name_Simplified. I have tried xlookup with wildcards but I don't know how to apply it in reverse for this.

Any help greatly appreciated!

TABLE 1

TABLE 2

The Result I am looking for:

CodePudding user response：

You could use the Fuzzy Lookup Add-In for Excel and do a fuzzy match between the Original Name column in Table 1 and the Contains_Name column in Table 2. For matches with a high level of similarity, you can could then lookup the Name_Simplified value based off the matched Contains_Name value.