How do I add

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)

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?

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

888 789 300

and so on
Thanks