How do I add
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: How do I add

  1. #1
    Guest

    Default

     
    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

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =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)
    ~Anne Troy

  3. #3
    Guest

    Default

    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

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

    Regards,

    Gary Hewitt-Long

  5. #5
    Guest

    Default

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

    888 789 300

    and so on
    Thanks

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com