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
<colgroup><col></colgroup><tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>
COLUMN A
Aveda Rosemary Mint Shampoo 33.8 oz
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody>
</tbody>
<colgroup><col></colgroup><tbody>
</tbody>