CODEWITHSUNDEEP
excel-formula
Lex
Lex

Reputation: 31

Dropdown List entries based on previous Dropdown list selection

I have an Excel Workbook with a cell with a list data validation with countries: USA, UK, RUSSIA, FRANCE.

I have another cell with cities such that when I click a country, say, USA in the first cell, the second cell populates it's drop-down with the cities in this country, like NY, DC.

I lastly have a third cell which also has a drop-down and whose values depend on what is selected in the second cell and it consists of languages like Spanish, English, Arabic. I have tried several custom lists, but I am only able to get the first cell right.

Upvotes: 0

Views: 374

Answers (1)

learnAsWeGo
learnAsWeGo

Reputation: 2282

This should work for you. Ranges are highlighted with same color, with header as the name of the range.

enter image description here

enter image description here

enter image description here

Upvotes: 1

Related Questions