There is a drop-down list for a list of countries. Depending on the country chosen, the second drop-down list will display the list of cities from that country.
Everything you need to know about Excel. Examples of functions and formulae, charts, tips, tricks, pivot tables, macros, power pivot
I hope you do enjoy this free blog. I only ask one thing from you in return, click in one of the ads
Showing posts with label INDIRECT function. Show all posts
Showing posts with label INDIRECT function. Show all posts
Thursday, 26 February 2015
Dependent drop-down lists in Excel
In a recent entry I talked about how to insert drop-down lists in Excel. Today I would like to show you how to insert dependent drop-down lists. Basically what this means is to have 2 or more drop-down lists with the second one having as content a range that depends on the selection made in the first one. Look at the images below:
Subscribe to:
Posts (Atom)

