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?
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Draco119 in forum Excel General
Last Post: 08-31-2018, 11:21 AM
By GeneralDisarray in forum Excel Tips
Last Post: 09-06-2017, 11:13 AM
By gameplayer in forum Excel General
Last Post: 11-18-2015, 05:24 PM
By ehardway111 in forum Excel General
Last Post: 06-07-2013, 04:36 PM
By 123Excel00 in forum Excel Formulas & Functions
Last Post: 02-02-2013, 05:06 AM
By JBeaucaire in forum Excel Tips
Last Post: 11-30-2012, 01:23 PM
By darkobird84 in forum Excel General
Last Post: 04-18-2011, 03:33 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1