Opposite of VLOOKUP? Pull through MISSING items?

[Miss Molko]

Hi guys!

So basically, long story short, I have over 6,500 products to go through and find out how many of them we haven't got High Resolution images for.

I have two columns of data:
Column A is a list of codes we SHOULD have High Res Images for
Column B is a list of codes that have High Res Images on our servers

So my plan is to get the code from Column A, look for it in Column B and if it's not there, pull that code through to Column C.
I need to do a sort of reverse VLOOKUP. I need it to pull through the ones it DOESN'T find a match for, not the ones it does.

Is that possible? I hope that makes sense! It's probably really simple and I'm just missing it - but any help would be greatly appreciated as my manager wants this completed by end of play today.

Thanks very much in advance, you guys are my heroes!


- Miss Molko

P.S. I attached an example workbook for you

EXCEL FORUM EXAMPLE HIGH RES.xlsx

So as you can see, I'd need AMI001B to pull through to Column C, as it's found in A but not in B.

The formula I've been using is =VLOOKUP(A2,B:B,1,FALSE), however this pulls through data that it DOES find. How do I make it so it pulls through codes it can't find?

[samba_ravi]

Will you please attach sample file with some examples and how your output would be

[Miss Molko]

Have done Cheers.

[ufopilot]

Something like this?

[ufopilot]

oops, I got Column A and Column B swapped on the last attachment

[Miss Molko]

oops, I got Column A and Column B swapped on the last attachment

Yes! That's exactly what I want! Thank you!