Hi all,
I have a lookup worksheet with two tables like these below:
Table 1: Unique list of countries with their codes
Country Country Code
------------------------------
United States US
United Kingdom UK
Germany DE
Table 2: List of cities with their country code, multiple cities per country code
Country Code City
---------------------------
US New York
US Chicago
US Detroit
UK London
DE Munich
DE Dortmund
I created a drop down (A) with a named range from Table 1 that shows the country names. Now I need to create a dependent drop down (B) that will contain city names based on the selected country. So basically the validation formula for B will need to do a lookup in Table 1 to get the country code for the selected country, do another lookup in Table 2 to get all the cities for the found country code and display them in drop down B.
Any help will be greatly appreciated!
Thank you.
Bookmarks