I have an Excel problem like this :
|Contains these:||Write these:||Item Name||Category|
|Medium Well Meat||MD|
I want the category rows to contain formulas that can look at the item name, check if they contain the words and write the exact thing.
Can you help me?