+ Reply to Thread
Results 1 to 10 of 10

Combine 2 data sets into one list based on user selection in drop downs.

  1. #1
    Registered User
    Join Date
    04-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Question Combine 2 data sets into one list based on user selection in drop downs.

    Good Morning,
    Pulling my hair out. I have 2 sets of data on 2 tabs that I need to combine based on user selection in 2 drop downs. I have a tab ("DO NOT ALTER") sort of working with a HLOOKUP for one column. I need it now to bring in data ("Qty) in the next column based on the result of the first column. I've included my spreadsheet which has notes. If you can actually help and get all the data to combine into one pretty equipment list that would be awesome.
    Thanks for any help.
    Cindy
    Attached Files Attached Files

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Combine 2 data sets into one list based on user selection in drop downs.

    your formala is showing errors
    =HLOOKUP('Lab Request'!$B$7,Purpose!#REF!,3,FALSE) have you deleted something? fix and repost
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,983

    Re: Combine 2 data sets into one list based on user selection in drop downs.

    No errors by me
    =HLOOKUP('Lab Request'!$B$7;Purpose!$1:$100000;3;FALSE)
    2007 ==> 2003 problem?


    Look at this solution
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Combine 2 data sets into one list based on user selection in drop downs.

    ah its the number of rows!

  5. #5
    Registered User
    Join Date
    04-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Combine 2 data sets into one list based on user selection in drop downs.

    martindwilson
    Thank you for taking a look. It must be a compatability issue. It isn't erroring on my spreadsheet. The "#REF" is $1:$100000. That is the formula I have working. I'm looking for a formula to drop in the corresponding qty in the next column.
    Cindy

  6. #6
    Registered User
    Join Date
    04-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Combine 2 data sets into one list based on user selection in drop downs.

    Thank you popipipo but that is not the formula I need help on. I actually need help with populating the "qty" column next to the "items needed" column. It needs to go find the qty from the appropriate tab and return it based on the results in "Items needed" column. I have no idea what kind of formula to use which is why it is blank.
    Cindy

  7. #7
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,983

    Re: Combine 2 data sets into one list based on user selection in drop downs.

    Is this better?
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    04-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Combine 2 data sets into one list based on user selection in drop downs.

    That is GREAT! I tried to copy the formula into "DO NOT ALTER" B3 and changed it like this =IF(A3=0,"",VLOOKUP(A3,INDIRECT('Lab Request'!$B$7),2,0)) to get that qty column working but it is giving me an error and I don't know why. Can you give one last bit of help? Thanks so much!

  9. #9
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,983

    Re: Combine 2 data sets into one list based on user selection in drop downs.

    The value in 'Lab Request'!$B$8' is PFA
    With the 'name manager' i named te range 'Application!$D$2:$F$42' also PFA
    INDIRECT('Lab Request'!$B$7)
    The vlookup formula searches then in range Application!$D$2:$F$42'

  10. #10
    Registered User
    Join Date
    04-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Combine 2 data sets into one list based on user selection in drop downs.

    Fabulous. Thank you so much for your help!

+ 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