Create conditional drop-down lists - Office Blogs

In Excel 2007 (and earlier), it's possible to create a drop-down list. By using the ... the right country. Second, we'll add three cities to pick from for each country.

blogs.office.com