yes, here's a sample workbook for you. I left the previous macro from above in Column C and added an example of how the additional keywords should ideally look in Column D.

Really not sure how to work this into a macro. doesn't have to be the same one, could be a new one altogether. The key to what I'm trying to do is that if any color variation matches what's in the product name, then all keywords get combined into the result in Column D.

Thanks a million for taking a look!