How to sort product by keyword in description then add a prefix

CluelessPerson - Mar 2, 2016 at 10:52 PM

I have thousands of products that I have to sort by category then assign a number prefix to its item ID. I was wondering if there was a way to:

1) Look up in the description of the item for keywords, e.g. "Gloves" or "Hand"

2) If the keyword exists, then add a number to a cell in the same row. i.e. if cell G5 contains gloves, print text "500" to cell A5

3) If the word does not exist, do not print text.

4) From there I can concatenate the generated text with the original item ID.

Thanks in advance for all the help!