Not totally getting the hang of vlookup

**mgoulart** · 02-10-2012, 04:47 PM

My boss gave me a project this week that was to take the inventory quantities from our inventory sheets and get them to show up on a customer's spreadsheet for the products he's asking for, and he wants me to do it using vlookup. Seems simple enough, BUT (there's always a "but"), 1) our part numbers aren't identical to the customers', 2) only boxes that are a certain condition (A & B) and box style (current) can be listed, and 3) there are multiple rows of the same item number. I'm not a total novice at Excel, and I can get vlookup to work on a less complex level, but I've realized this is a much greater task than I'm used to and I'm starting to get really frustrated with it, so I am asking the Excel gods for some help.

I've attached both spreadsheets.

The Surplus report is the customer's report, and the Inventory is our inventory.

Any help is greatly appreciated. Thank you!

**JP Romano** · 02-10-2012, 05:21 PM

The T3 is password protected... can you copy to a new spreadsheet?

**JP Romano** · 02-10-2012, 05:21 PM

Sorry...ignore that

**JP Romano** · 02-10-2012, 05:26 PM

What columns can be used to illicit a match? The descriptions don't appear to be the same, or am I missing something?

**mgoulart** · 02-10-2012, 05:32 PM

Originally Posted by JP Romano

What columns can be used to illicit a match? The descriptions don't appear to be the same, or am I missing something?

I would be using the Product Number from the Usage Report to find a match from the T3 report, and getting the quantity from the T3 report to go into the Qty column on the Usage Report. If that makes any sense....

**JP Romano** · 02-10-2012, 05:40 PM

Sorry, didn't you say that the product numbers didn't match though? Should Part Number = Product Number?
Apologies - I'm a little confused!

**mgoulart** · 02-10-2012, 05:53 PM

Originally Posted by JP Romano

Sorry, didn't you say that the product numbers didn't match though? Should Part Number = Product Number?
Apologies - I'm a little confused!

Right. Part Number = Product Number. We will be changing it so that our Part Number will be identical to the Product Number from the customer's report next week, so hopefully that obstacle will be out of the way shortly. But I'm still not sure it's even possible...?