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:
Solved! Go to Solution.
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
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: