+ Reply to Thread
Results 1 to 6 of 6

Return Multiple Values Based On Dropdown List Selection

  1. #1
    Registered User
    Join Date
    07-01-2009
    Location
    Seoul, South Korea
    MS-Off Ver
    Excel 2003
    Posts
    21

    Return Multiple Values Based On Dropdown List Selection

    Once again, I have come to seek assistance from the excel masters that grace this forum.

    I am trying to create list of values based on a selection from a Data Validation Dropdown List.

    Now previously when I used this technique, I only had to return 1 value, so a simple vlookup function did the trick, but this time, its proving a bit more complex.

    I have a list of labor crews with details for each worker

    IE: Crew 3-1
    -1 Foreman, Productivity: 5, Rate: 25
    -1 Common, Productivity: 3, Rate: 14

    Crew 3-2
    -1 Foreman, Productivity: 10, Rate: 25
    -1 Bricklayer, Productivity: 8, Rate: 20
    -1 Common, Productivity: 3, Rate: 14

    Basically, I have a dropdown list with the available crews. From that selection I would like to populate the adjacent cells with all the labors corresponding to that corresponding crew.

    Researching, I found some answers with array formulas, but was having trouble understanding/applying to this instance. have attached a sample, that I have been working on and would appreciate any guidance possible.

    Thank you
    Attached Files Attached Files
    Last edited by tigabalm; 04-01-2010 at 08:47 PM.

  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: Return Multiple Values Based On Dropdown List Selection

    that workbookt has no relation to what you've asked about!
    you say
    -1 Foreman, Productivity: 5, Rate: 25
    workbook shows
    Type Q'ty Unit
    3-1 Formwork Common 0.097 M2
    "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
    Registered User
    Join Date
    07-01-2009
    Location
    Seoul, South Korea
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Return Multiple Values Based On Dropdown List Selection

    Sorry I should have referenced my workbook better.

    So in the dropdown box at cell H2: If I select Crew 3-2, I'm trying to get the following:

    Cell I2: Formwork Common; Cell J2: 0.097
    Cell I3: Formwork Carpenter; Cell J3: 0.178

  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: Return Multiple Values Based On Dropdown List Selection

    i'd tackle it like this helper columns on sheet 1
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-01-2009
    Location
    Seoul, South Korea
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Return Multiple Values Based On Dropdown List Selection

    Thank you martindwilson! that is what i was looking for. one question though, the final application for this has changed and instead of the laborers being listed vertically with their values listed next to them, would it be possible to go the opposite and have the laborers listed horizontally and their values listed directly beneath them?

    Thanks again for all your help!

  6. #6
    Registered User
    Join Date
    07-01-2009
    Location
    Seoul, South Korea
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Return Multiple Values Based On Dropdown List Selection

    How do I delete a post?
    Last edited by tigabalm; 04-01-2010 at 07:41 PM.

+ 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