EXCEL: Comparing Tables 1

[BIGALINWALES]

Hey,

Have two columns of different sizes. I need to compare the smaller one with the larger one to see which ones are missing. Is there anyway to do this easily? I've been trying VLOOKUP's and COMPARE's but am getting no where

Can anyone help?
Thanks in advance

Al

 

[xlbo]

Next to the bigger list:

If(isna(vlookup(A2,[Small_List],1,false)),"MISSING","")

filter on new column for "MISSING"

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[BIGALINWALES]

Thanks for that, sorry maybe I should have explained further....
In column 1 there are 415 items in order in cells A2-A416.
In column 2 there are 515 items in order in cells B2-B516.

Column 1 contains values from column 2, I need to find the 100 that are missing.

005P008 005P008
005P011 005P011
007D004 007C001
007E002 007D004

In the example I need it to show that 07C001 is missing
Hope this helps explain it further,

thanks

Al

 

[xlbo]

same deal
In col 3

=if(isna(vlookup(B2,$A$1:$A$416,1,false)),"MISSING","")
copy down

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[BIGALINWALES]

Thanks...