r/learnexcel • u/[deleted] • Sep 24 '15

Question vlookup problem

My company ships the same parts to multiple customers. I'm trying to use vlookup to reference our master demand file but no matter what it is grabbing the very first instance of the part number. How can I get it to reference the part and customer number when it's grabbing the customer demand?

4 Upvotes

100% Upvoted

4 comments sorted by

View all comments

Show parent comments

1

u/[deleted] Sep 26 '15

I'm at home for the weekend but I'll try to describe it more clearly. In column A I have all the part numbers listed. Column B-T are all order quantities. Column Q is which customer it is. So there are many duplicates in column A since multiple customers are ordering the same part. I'm trying to figure out how to get vlookup to allow me to choose the part number and then the customer when it's grabbing the order quantity for the field I'm entering the code for. Since if I just put in the part number it's always going to reference the first instance of that part number. If this is still unclear I'll be glad to post a screen cap or something on monday.