I have a number of SKUs (18k) that have Item Descriptions with key Words spread around in them. I need to populate FIVE or SIX columns per row with data based on the key Words found in the Item Descriptions for each SKU. So if the Item Description contains "SiC/SiC/FKM" then Col C= "FKM", Col D= "Sic/Sic", Col E= blank, Col F= "Mechanical", Col G= blank.

There are around 300 different Key Words and each of these will have unique values to fill into Columns C thru G.

I am currently using this simple code in each column and changing the outputs, then copying and pasting those first cells in Columns C thru G. I then copy and past just the values, find and replace #VALUE!, select everything and sort it based on Column C (Since it will always have something populated after the formulas have been run). I proceed to find the last populated cell in Column C and proceed to do the whole thing over again with the next Key Word.

The Code I have been using:
Please Login or Register  to view this content.
It is very time consuming. If I have one formula that populated all five columns and all I had to do was the sorting and changing the FIND text string Key Word that would be awesome. I am very new to Excel Formulas and could really use some help!!!