How do I add

[Guest]

Hi,
I have 2 sheets one has partnumber lotnumber quanity, second sheet has same but more lotnumbers. I want to add lot and quanity to each line under the correct partnumbers it goes with.

I hope i explained this correctly

JPS

 

[Anne Troy]

=vlookup(A,B,C)

Where:

A = cell with part number on sheet 1
B = Sheet2!A:C (if those are 3 columns on sheet2)
C = column to return (i.e., 2 for lotnumber, 3 for quantity)

 

[Guest]

Thanks
But its not quite what I wanted.
I need it to add rows or columns under the corect Partnumber so I have a consoledated list of lots and quanity.

my first sheet has part, lot, qty, locations
my second sheet has all parts and lots, qty, locations. I need to copy all lots, qty to sheet1 under the apporate parts.

Thanks in advance JPS

 

[gplhl]

On 2002-02-28 13:45, Anonymous wrote:
Thanks
But its not quite what I wanted.
I need it to add rows or columns under the corect Partnumber so I have a consoledated list of lots and quanity.

my first sheet has part, lot, qty, locations
my second sheet has all parts and lots, qty, locations. I need to copy all lots, qty to sheet1 under the apporate parts.

Thanks in advance JPS

Do you mean e.g.

Sheet1 has:

Part 999 qty 100

Sheet2 has:

Part 999 qty 200

So these would need consolidating so that it read:

Part 999 qty 300

Taking into account Lot number?

 

[Guest]

Yes, Lots would be listed seprately with qty
part lot qty
999 123 100
456 200

888 789 300

and so on
Thanks