+ Reply to Thread
Results 1 to 4 of 4

VLookup with multiple orders

  1. #1
    Registered User
    Join Date
    11-08-2012
    Location
    United States
    MS-Off Ver
    2007
    Posts
    39

    VLookup with multiple orders

    Attached I have a sample workbook w/ two sheets (FACTORY and HQ). The "FACTORY" sheet is complete and the "HQ" sheet needs the correct formulas in column E-H to bring over the data from "FACTORY". Where I'm confused is when there are two identical parts (in this example A-1010) with two separate purchase order numbers, resulting in two different stages of the production.

    Anybody interested in assisting tonight?

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: VLookup with multiple orders

    See attached file with formulas in it.
    They are array formulas so if you edit one of them do not forget to press CTRL+SHIFT+ENTER when done otherwise it will give you an error.
    Attached Files Attached Files
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: VLookup with multiple orders

    You can use Sumproduct to get the results you are looking for.

    Find out more on Sumproduct here.http://www.xldynamic.com/source/xld.SUMPRODUCT.html

    Check out the attached.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-08-2012
    Location
    United States
    MS-Off Ver
    2007
    Posts
    39

    Re: VLookup with multiple orders

    Thanks guys

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1