Pulling Out Certain Words from String and Outputting to succeeding columns

[muddobber26]

Hello - I have a description field that consists of anywhere from a 2 to 12 word description. The data set I have consists of about 12,000 different descriptions. I have created a "key words" (~45 words) list based on a cursory review of the descriptions. I am looking to right some type of macro or workflow in order to look at each "description" and pull out any of the "key words" and output them to additional columns. It is my way of distilling a bunch of freeform descriptions into certain common words. Because the list is long, I can't write a simple if/then statement. I have attached an example data set that has the "description", "key words" and "desired outputs". Can someone help me with this?

[BrandonB]

One approach - workflow attached:

[Felipe_Ribeir0]

Hi @muddobber26 

One way of doing this