Dropdown List Conditional on Two or more Drop Down List

Hello,

use the same principle that you apply for the first dependent drop-down, i.e. create range names for all the options in the second drop-down that point to cells with the desired values. Example

First drop-down: Continents. Africa, America, Asia, Australia, Europe. You need named ranges for each continent with the countries for the continent.

Second drop-down: Countries. Let's say Europe is selected and the named range for Europe has France, Italy, Spain. Now you need range names for each of these countries with the cities of that country.

Third drop-down: Cities. Let's say France is selected. The drop-down shows Avignon, Marseille, Paris.

It's a lot of work to set this up, because with each dependency, the options for which you need to create range names multiply exponentially.


If it's not a cascade, but a combination of two factors, use two drop-downs, for example Fruit with Apple, Orange, Banana, and another drop-down for Size with Small, Medium and Large as options.

Now create range names for each of the possible combinations, so AppleSmall, AppleMedium, AppleLarge, OrangeSmall, OrangeMedium etc.

If the Fruit dropdown is in A1 and the Size dropdown is in A2, use Indirect(A1&A2) to get the range name for the dependent dropdown.

Let me know if that helps.