HI Everyone!

I hope your all well!

I have a bit of an interesting one here,

In column A there is a list of product names. Within these names there are keywords like perfume or lotion or hair etc

Is it possible to use formula to look for these specific words within a cell and return a predetermined word.

My reason for doing this is so I can easily put each product in a category.

To make it a little more complicated - can we make it so multipule words will return the same category.

Eg - The category BATH will be used for product names containing; wash, shower gel, shower, bath.

I have included an example of what I was going for in the attached spreadsheet. I have filled in the categories in column B to show what I was going for BUT that is the column that I'm looking to fill in with the formula.

Any help that you can give will be much appreiated

Cheers