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.