I’m trying to build a macro that can help me categorize groups of phrases/words. I’ll give a simplified example to help explain. I was thinking I could filter Column A and Autofill the results in Column B.

Simplified Example:
Column A
Fishing
Fishing rod
Apple
Apple sauce
Fisherman
Appleton

I’d search for “fish” and all results would get “Fishing” and then for “apple” and Tag those “Apple Pie”.

The problem is that I have 10,000 words/phrases and about one hundred category tags. What’s the easiest way to do thing?

If I had a separate work sheet with appropriate filters and their resulting tags? I’m really open to suggestions but I think a macro could help me tremendously. I've developed an index formula but its a bit complicated and it's too slow and never completes.

Thanks for the help!!!