I need to match information from one table to information in another

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

it would be mighty helpful to have a sample file.

Say your keywords are in column A and your allocated labels in column B. Say you new list of keywords is in column C. Then the following formula in (say) cell D2 would be: =VLOOKUP(C2,A:B,2,0)

Then filter for #N/A, these are the ones that need to be added to your master list.

Thanks for your help - I've uploaded the example

Did that work?

It looks like it does! Epic work - would you just be able to give me a bit of a break down of it please so I can transfer this elsewhere please?

Thanks again all!

A break down how so? You want to know how it works?

Yes please - just if i have any probs I can sort it - also like to learn it.

cheers

=IFERROR(INDEX(A:A,MATCH(H5,B:B,0)),"")

INDEX(A:A = This is where index looks to search in reference to the match.

MATCH(H5,B:B,0) = Looks for whatever is in H5 in the Column B and is looking for the exact value (that is what the 0 means)

=IFERROR(INDEX(A:A,MATCH(H5,B:B,0)),"") = This means if the formula returns an error it will be left blank.