+ Reply to Thread
Results 1 to 3 of 3

Multiple linking dropdown list

  1. #1
    Registered User
    Join Date
    04-03-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Multiple linking dropdown list

    I have three drop down list.

    1. Country
    2. State or Providence
    3. Station

    There are 177 countries but only "United_States" and "Canada" have States or Providences. When "United_States" or "Canada" are selected as the Country, dropdown list number 3 is dependent on dropdown list number 2. For all the other countries dropdown list number 3 is dependent on dropdown list number 1.

    I have named ranges for all the countries and for all the States and Providences. I was trying to do an If then statement combined with an indirect formula in my data validation cell but I can't get it to work. I will try to get a sample file if necessary. Thanks for any help!

    John

  2. #2
    Forum Contributor
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 365, Windows 10
    Posts
    110

    Re: Multiple linking dropdown list

    some sample file with short explain (optimal outcome) would help.

  3. #3
    Registered User
    Join Date
    04-03-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Multiple linking dropdown list

    Figured it out. There was an issue with me named ranges. Thanks

+ 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