I need help with a statement, I know the logic but not sure how to write it in Excel. If someone can help me out that would be great.
I need a statement that does this:

If B2 contains the word shampoo then "Hair Care ~ Shampoo", OR if B2 contains the word conditioner then "Hair Care ~ Conditioner", OR if B2 contains cleanse then "Hair Care ~ Shampoo", OR if B2 contains Treatment then, "Hair Care ~ Treatment", Etc...

This is what I have thus far and it works for only shampoo.. but, where do I put the OR statement(s)? does excel do loops? ughhhh lol Help me please

=IF(ISNUMBER(SEARCH("shampoo",B2)),"Hair Care ~ Shampoo","")