I have 2 worksheets with part numbers and quantities in stock for 2
separate warehouses. I have a 3rd sheet with commonly used parts on.
For the commonly used part Nos, I want to get the quantity in stock for
each Warehouse.
i.e.
PART NUMBER WAREHOUSE 1 STOCK WAREHOUSE 2 STOCK
abc43 55 23
qwe21 35 87
fde182 12 14

I can see on the preview that my table above looks rubbish!
Hopefully you can see what I mean?
Part# abc43 - Warehouse 1 stock 55, Warehouse 2 stock 23

I have spent several hours looking through the various functions with
no luck.
Any help greatly appreciated.


--

------------------------------------------------------------------------
's Profile: http://www.excelforum.com/member.php...o&userid=34701
View this thread: http://www.excelforum.com/showthread...hreadid=544707