Power Query Replace Values

[wsnyder]

Hi,

I have 2 tables.
Table1 is a table with 2 columns. Work Order Nbr | Customer Description of problem: 60,939 rows and growing.
Table2 has 2 columns, Keywordphrase | Bucket: 104 rows and growing.

I imported the Tables into Power Query in Excel.
For Table1, I made a copy of the Customer Description Column. It is this column I need to replace wi the Bucket value from Table2 if the Keywordphrase exists as a string/substring
In no replacement is found, then the replacement should be "Other"

Any ideas on this Bulk Replacement?

Thanks,
-w