Healthcare project: group many data points together

Thanks for taking some time to help!

See attached. In column A that would be a unique identifier to separate each exam but to protect privacy I just made it a column of numbers.

Column B is the column I'm trying to work with, this is just a small snippet of the procedures but you can get the idea from looking at it.

Ultimately, I would want Excel to be able to let me write a formula that could be pretty big but it would say something like "If you see (x-ray chest 2 views; CT chest with contrast; CT chest without contrast; x-ray abdomen) in column B then in column F show the word "Body"; if you see (x-ray ankle left 3 views; x-ray foot right 2 views; x-ray knee right 2 views; MRI hip left with contrast) in column B then in column F show the word "MSK""

Does that make sense? I know if-then formulas can do this on a small scale but I want to be able to do it on a large scale with many different iterations.

Column D is a sample of the report data I want excel to sift through to find numerical values in the range of 6 to 20, but being able to have a wider range rather than having to do independent ones of saying "find 6 mm" then run it, then "find 7 mm" and run it. Not sure if that's possible.

Thanks!