Search for key words within columns of an excel sheet

[ltensmeyer]

I'm working on a macro to read medical records then add an estimated treatment duration based on key words in the diagnosis. I would like to have these words stored in an excel sheet so I can update them more easily. this is what my spreadsheet looks like:

Here's what I'll be reading from records:

the desired output is this:

How do I go about checking the primary diagnosis column for key words in my excel spreadsheet then creating a new field called duration with a value matching whichever column the keyword was found in?

EDIT: I could also set up my excel sheet this way:

[geraldo]

@ltensmeyer 

If the example that you put as the desired output was in the examples of the prints, it would be easier to give a solution. The example is not in the list of prints

[ltensmeyer · Accepted solution]

In case anyone is looking at this in the future, I realized that this was easily achieved with a find and replace function. I made it work simply by inputting both files and changing the settings as such: