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?
Bookmarks