Excel Drop Down Lists for Country and City

[vandresque]

Awesomee! simple and yet so useful

[contextures]

@vandresque Thanks, It's a nice technique for a simple set of dependent drop down lists.

[contextures]

@DLiberator78, thanks, I'm glad you liked the INDIRECT technique.

[DLiberator78]

This is an awesome tutorial, thank you so much. I usually use VLOOKUP tables to do a similar things, I didn't know about the INDIRECT command in data validation. Thanks again.