Dropdown

[GColeman]

This should be simple.

In B3 I have a dropdown list of 3 cities
In C3 I want another dropdown list, based on which selection was made in B3.

Scenario: We are having engagements in 3 cities this year, all with multiple dates

If user selects "City A", I want the dropdown in C3 to show only those dates.
If user selects "City B", I want the dropdown to show only those dates.

I tried the LOOKUP functions, but they didn't seem to support a cell with a dropdown list (dates) in it

 

[tybaltlives]

Check out this link. If you follow their setup (but change to cities and dates) it should do what you are trying to do.

http://www.contextures.com/xlDataVal02.html