Hi All,

I've been researching for weeks now on an easy way to help me categorize my products. I have over 3000 of them to do.
I think Vlookup is what I'm looking for but just can't figure out how to implement it on my data.

I have multiple keywords assigned to each category, how can I use the keywords to assign the relevant category to my product? Is it even possible to use an array in VLookup's first element?

The data I have is:

Product Title - Category - Keywords(for each category)
SDS1234 - Bugs - Butterfly, Bee, Worm, Ant etc.

Any help is much appreciated as well as suggestions if I'm on the right track here with Vlookup.

Kind Regards
Gidion