@JetKaren: tacape isn't the OP. It doesn't really matter whether you put the VLOOKUP in File 1 or make a copy and put it in File 3 ... it's the same formula looking at the same data in File 2. I have made a copy because that's what the OP said he wanted ... presumably so that he can track before and after quantities.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi everyone,
I was able to get what I needed. Thank you all so much, you saved me a ton of time and some brain cells.
Quick question, why is the Table Array A:C? I get the $ reference, but why A : C? Can it just be A since the sku is in column A?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
justanot 
Register To Reply
Bookmarks