If Substring from a List contains Subtring, return that item from the list

[donkey shrek]

I have a column containing broken/good domains

I want to compare it to a list containing all the correct domains, and return those from this list that partial matches with [Email Domain]

 

[johnny51981]

I'm not sure if that can be done, with as exact as Power Query feels the need to be. Someone might have a better solution to match exactly the how you are looking to achieve this.

But as a meantime, the route I would take is to use a Translation and Fallout approach. Create a table of all of the domains you have entries (broken and clean) for in one column and the clean translations that you will want to change them to. Add that table to your Query Editor. Then create a Fallout query that shows if not on the Translation table but in the data table then fallout. Those would be the ones that you would need to add to the translation table.

I hope this makes sense.