Excel, Categorize from Matching Cells


I have an Excel problem like this : 








Example :

Contains these: Write these:   Item Name Category
Cook CO   Cooked Meat CO
Raw RW   Raw Meat RW
Medium MD   Cooked Lobster CO
      Raw Ingredients RW
      Cook Shrimp CO
      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?

Thank you



By: Adelia

Leave a Reply

Your email address will not be published. Required fields are marked *