@IF help

[verbena]

I have a 3000 line spreadsheet with 2 columns. The column A contains product titles. Column B contains a category the product fits into based on the title on column A. I need help in creating a @IF formula that I can copy down and populate column 2. See below example.

COLUMN A

Aveda Rosemary Mint Shampoo 33.8 oz Aveda Be Curly Conditioner 33.8 oz COLUMN B Shampoo Conditioner Skincare The formula in column B would identify the word "shampoo" in the title and assign "Shampoo" as the value of column B. If column A has the word "Conditioner", it would assign the value "conditioner" on column B. Can someone help put this together? <colgroup><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

<colgroup><col></colgroup><tbody>
</tbody>

 

[mikerickson]

Do you have a list of possible types some where in the workbook?

 

[verbena]

No, but I could create a list on a tab if necessary