How do I add

G

Guest

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
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
=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)
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
Yes, Lots would be listed seprately with qty
part lot qty
999 123 100
456 200

888 789 300

and so on
Thanks
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,192
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top