medium10 pts · first answer countsexceldata-validation
A second dropdown that depends on the first
A2 has a dropdown of states. You created named ranges called Kerala and Gujarat listing their cities. What List source in B2's data validation shows only the cities of the state chosen in A2?
Discussion 0
Join free to post in the discussion.