+ Reply to Thread
Results 1 to 2 of 2

How to accomplish large data cascading drop-downs?

  1. #1
    Registered User
    Join Date
    Colorado Springs, CO
    MS-Off Ver
    Excel 2007

    How to accomplish large data cascading drop-downs?

    Suppose your main list has students and location information, so your columns are Last Name, First Name, Email, Region, State, Zip. Since you are also exporting this data to a SharePoint list you need the location information to be exact. This is why I need cascading/dependent drop-downs for location information.

    I have tried named ranges which works for the Region(6 items) & State (50 items), so that there are 6 named ranges with the corresponding states in them. However, this method gets a little too much when you get down to Zip in which you need 50 named ranges.

    Is there a way, other than named ranges, to get distinct cascading/dependent drop-downs for large lookup datasets?

    Thank you.

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    MS-Off Ver

    Re: How to accomplish large data cascading drop-downs?

    It sounds like your data is in a tabular format.

    With the State dropdown in D2, your zipcodes in column B starting in B2, and your states in A starting in A2, you can use this data validation formula for zips:


    Adjust accordingly to fit your sheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating Dependent or Cascading Drop Downs
    By Draco119 in forum Excel General
    Replies: 3
    Last Post: 08-31-2018, 11:21 AM
  2. Dynamic Cascading Drop-Downs Using INDEX & MATCH
    By GeneralDisarray in forum Excel Tips
    Replies: 4
    Last Post: 09-06-2017, 11:13 AM
  3. [SOLVED] Turning a large flat file into several drop downs
    By gameplayer in forum Excel General
    Replies: 7
    Last Post: 11-18-2015, 05:24 PM
  4. Cascading two tier drop downs in form control
    By ehardway111 in forum Excel General
    Replies: 5
    Last Post: 06-07-2013, 04:36 PM
  5. Best way to create form with multiple cascading drop downs.
    By 123Excel00 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2013, 05:06 AM
  6. Replies: 7
    Last Post: 11-30-2012, 01:23 PM
  7. How to simplify large database & use multiple drop downs
    By darkobird84 in forum Excel General
    Replies: 1
    Last Post: 04-18-2011, 03:33 PM

Tags for this Thread


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