+ Reply to Thread
Results 1 to 7 of 7

Column B drop down list with 2 options, columns C & E with dependent drop down lists

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    nashville, tn
    MS-Off Ver
    Excel for Mac 2011
    Posts
    10

    Column B drop down list with 2 options, columns C & E with dependent drop down lists

    I work at a non-profit booking trips for people overseas. I work with 2 separate countries and am trying to simplify the process of budgeting the trips. There are only so many places we visit, but we have a few transportation options and lodging options depending on the country.

    I have a spreadsheet that I've made where you would select the country in column B, then using the INDIRECT function as described on this page (http://www.contextures.com/xlDataVal02.html) I've created a drop down list in column C for places we visit. Now, in Column E I want to have another drop down list to choose where the group will stay based on the country choice in column B (I will also have yet another column for transportation options with a drop down list). I cannot seem to use the INDIRECT function as the named lists are used for column C. I thought that maybe a nested IF function would work, but I can only get it to accept that if I have only 1 choice in the drop down. Once I have multiple choices in the drop down list I get the error that the list source must be delimited or a reference to a single row or column. So...any help on creating more drop down lists based on the country selection would be great and I hope that all made sense. Thanks in advance for the help!
    Last edited by betic; 09-26-2012 at 12:17 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,335

    Re: Column B drop down list with 2 options, columns C & E with dependent drop down lists

    could you upload a sample for us to look at please?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-12-2012
    Location
    nashville, tn
    MS-Off Ver
    Excel for Mac 2011
    Posts
    10

    Re: Column B drop down list with 2 options, columns C & E with dependent drop down lists

    Sorry about that. Here is the list with generic data and descriptions.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-12-2012
    Location
    nashville, tn
    MS-Off Ver
    Excel for Mac 2011
    Posts
    10

    Re: Column B drop down list with 2 options, columns C & E with dependent drop down lists

    And the values are all on the Budget tab. The first tab isn't currently used.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,335

    Re: Column B drop down list with 2 options, columns C & E with dependent drop down lists

    you said you wanted a drop-down for accomodation, based on the country?

    change the DV in E to =INDIRECT($B2&"Accomodations")

  6. #6
    Registered User
    Join Date
    09-12-2012
    Location
    nashville, tn
    MS-Off Ver
    Excel for Mac 2011
    Posts
    10

    Re: Column B drop down list with 2 options, columns C & E with dependent drop down lists

    Thank you. That worked perfectly!

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,335

    Re: Column B drop down list with 2 options, columns C & E with dependent drop down lists

    happy to help, and thx for the star

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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