Hi All,

This may be fairly simple but I need to come up with a formula to save a heap of time.

I have long list of Keywords (about 5,000) and each of them I need to allocate allocate a type to: Pure Brand, Brand or Generic.

Now I have gone through and created a table with each of the words and manually given each the relevent label - the problem is that I need to run a search every week and these keywords may well change.

so what I need is a formula/process that means that it will automatically search out the terms that have been used before and allocate the relevent tag - I can then come along, filter the remainder and then allocate the tag it requires.

Cheers for your help!

Myles