Vlookup for this?

[Antonow]

Hello guys,I need a bit of help! ok, i've been trying to do this without macros, and i'm going nuts.I have 2 workbooks, one with codes that need to be added to the current one I have here. The thing is, I need to check and copy the new codes to our current workbook, but i've been doing it manually.. and it's driving me nuts.I don't really know how to use Vlookup between different workbooks, so what i've done is, make a new worksheet, copy both updated (Column A) and current codes (Column B) and I was checking one by one, and putting the ones in a column of codes that need to be added. (column C) and it's a long list.So, how can I make a quick thing like If column A has codes that doesn't exist in column B, Copy them to Column C.I know it's a mess, but i need to do this fast and work in a permanent or long term solution later.Thanks for the helpIs there a quick fix for this?

 

[PatOBrien198]

Try something like:

in column C
=IF(COUNTIF($B$2:$B$999,A2)=0,A2,"")
copy this formula down
change the B column range to suit your needs, then you can filter on Column C for any non blanks, and those will be the codes you need to add

 

[Antonow]

What i've came up is.. Updated in column A, current Column B, and in column C i've used =VLOOKUP(B3;$C$3:$C$218;1;FALSE)

So when it doesn't find any matching value it gives #N/D and I know that the code from column A does not exists.

Is that right?

 

[PatOBrien198]

try...

=VLOOKUP(A3;$B$3:$B$218;1;FALSE)

so you're looking thru the A column for those not found in the B column

 

[Antonow]

Both of them worked, Thank you

 

[PatOBrien198]

If you don't need to know which codes are the new ones, and just need a new list, you could:

copy both sets to the same column (one under the other)
Use the Data tab | Sort & Filter group | Advanced option, check the "Unique Records Only" and "Copy to new location" and give it a new column to paste the results to.