Search for key words within columns of an excel sheet

Question

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:

ltensmeyer · Accepted Answer

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: