Spreadsheet: 235060d1368311639-please-help-with-multiple-dependant-drop-down-lists-drop-down-list
Sheet: Subs-Country

Subsidiaries |  | HA |  | HB |  | HC |  | HF |  | HG |  | HH |  | HI |  | HK |  | HM |  | HN |  | HO |  | HQ |  | HR |  | HS |  | [NAME]
HA |  | Bahamas |  | Brazil |  | China |  | Afghanistan |  | Argentina |  | Andorra |  | Holy See |  | American Samoa |  | Anguilla |  | Aland Islands |  | Albania |  | Belgium |  | Armenia |  | Germany |  | Ireland
HB |  | Barbados |  |  |  | Hong Kong, Special Administrative Region of China |  | Algeria |  | Bolivia, Plurinational State of |  | Colombia |  | Italy |  | Australia |  | [NAME] and [NAME] |  | Denmark |  | Austria |  | Netherlands |  | Azerbaijan |  | Georgia |  | United Kingdom of Great Britain and Northern Ireland
HC |  | Bermuda |  |  |  | Macao, Special Administrative Region of China |  | Angola |  | Chile |  | Ecuador |  | [NAME] |  | [NAME] |  | Aruba |  | Estonia |  | Bosnia and Herzegovina |  | Suriname |  | Belarus |  | Israel
HF |  | Canada |  |  |  | Mongolia |  | Bahrain |  | Falkland Islands (Malvinas) |  | Gibraltar |  |  |  | Cambodia |  | Belize |  | Faroe Islands |  | Bulgaria |  | Ghana |  | Kazakhstan |  | Turkey
HG |  | Puerto Rico |  |  |  |  |  | Bangladesh |  | Paraguay |  | Guyana |  |  |  | Cook Islands |  | British Virgin Islands |  | Finland |  | Croatia |  | Nigeria |  | Kyrgyzstan |  | Luxembourg
HH |  | [NAME] and Miquelon |  |  |  |  |  | Belgium |  | Peru |  | Portugal |  |  |  | Fiji |  | Cayman Islands |  | Greenland |  | Cyprus |  |  |  | Republic of Moldova
HI |  | United States of America |  |  |  |  |  | Benin |  | Uruguay |  | Spain |  |  |  | Guam |  | Costa Rica |  | Iceland |  | Czech Republic |  |  |  | Russian Federation
HK |  | United States Virgin Islands |  |  |  |  |  | Bhutan |  |  |  | Venezuela, Bolivarian Republic of |  |  |  | Indonesia |  | Cuba |  | Latvia |  | Greece |  |  |  | Tajikistan
HM |  |  |  |  |  |  |  | Botswana |  |  |  |  |  |  |  | Japan |  | Dominica |  | Lithuania |  | Hungary |  |  |  | Turkmenistan
HN |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Kiribati |  | Dominican Republic |  | Norway |  | Macedonia, The former [NAME] of |  |  |  | [NAME]
HO |  |  |  |  |  |  |  | Burundi |  |  |  |  |  |  |  | Korea, Democratic People's Republic of  (North) |  | El Salvador |  | Sweden |  | Malta |  |  |  | Uzbekistan
HQ |  |  |  |  |  |  |  | Cameroon |  |  |  |  |  |  |  | Korea,  Republic of (South) |  | Grenada |  |  |  | Montenegro
HR |  |  |  |  |  |  |  | Cape Verde |  |  |  |  |  |  |  | Lao People's Democratic Republic |  | Guatemala |  |  |  | Poland
HS |  |  |  |  |  |  |  | Central African Republic |  |  |  |  |  |  |  | Malaysia |  | Haiti |  |  |  | Romania
[NAME] |  |  |  |  |  |  |  | Chad |  |  |  |  |  |  |  | Marshall Islands |  | Honduras |  |  |  | Serbia
 |  |  |  |  |  |  |  | Comoros |  |  |  |  |  |  |  | Micronesia, Federated States of |  | Jamaica |  |  |  | Slovakia
 |  |  |  |  |  |  |  | Congo |  |  |  |  |  |  |  | Myanmar |  | Mexico |  |  |  | Slovenia
 |  |  |  |  |  |  |  | Congo, Democratic Republic of the |  |  |  |  |  |  |  | Nauru |  | Montserrat |  |  |  | Switzerland (Customer: Rauch Wodnau)
 |  |  |  |  |  |  |  | Côte d'Ivoire |  |  |  |  |  |  |  | New Zealand |  | Netherlands Antilles
 |  |  |  |  |  |  |  | Djibouti |  |  |  |  |  |  |  | Niue |  | Nicaragua
 |  |  |  |  |  |  |  | Egypt |  |  |  |  |  |  |  | Norfolk Islands |  | Panama
 |  |  |  |  |  |  |  | Equatorial Guinea |  |  |  |  |  |  |  | Northern Mariana Islands |  | [NAME] Nevis
 |  |  |  |  |  |  |  | Eritrea |  |  |  |  |  |  |  | Palau |  | [NAME]
 |  |  |  |  |  |  |  | Ethiopia |  |  |  |  |  |  |  | [NAME] |  | Saint Vincent and the Grenadines
 |  |  |  |  |  |  |  | France |  |  |  |  |  |  |  | Philippines |  | Saint-Barthélemy
 |  |  |  |  |  |  |  | French [NAME] |  |  |  |  |  |  |  | Pitcairn |  | Saint-Martin (French part)
 |  |  |  |  |  |  |  | French Polynesia |  |  |  |  |  |  |  | Samoa |  | Trinidad and Tobago
 |  |  |  |  |  |  |  | Gabon |  |  |  |  |  |  |  | Singapore |  | Turks and Caicos Islands
 |  |  |  |  |  |  |  | Gambia |  |  |  |  |  |  |  | Solomon Islands
 |  |  |  |  |  |  |  | Guadeloupe |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Guinea |  |  |  |  |  |  |  | Taiwan
 |  |  |  |  |  |  |  | Guinea-Bissau |  |  |  |  |  |  |  | Thailand
 |  |  |  |  |  |  |  | India |  |  |  |  |  |  |  | Timor-Leste
 |  |  |  |  |  |  |  | Iran, Islamic Republic of |  |  |  |  |  |  |  | Tokelau
 |  |  |  |  |  |  |  | Iraq |  |  |  |  |  |  |  | Tonga
 |  |  |  |  |  |  |  | Jordan |  |  |  |  |  |  |  | Tuvalu
 |  |  |  |  |  |  |  | Kenya |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Kuwait |  |  |  |  |  |  |  | Vietnam
 |  |  |  |  |  |  |  | Lebanon |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Liberia
 |  |  |  |  |  |  |  | Libyan Arab Jamahiriya
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Madagascar
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Maldives
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Martinique
 |  |  |  |  |  |  |  | Mauritania
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Mayotte
 |  |  |  |  |  |  |  | Monaco
 |  |  |  |  |  |  |  | Morocco
 |  |  |  |  |  |  |  | Mozambique
 |  |  |  |  |  |  |  | Namibia
 |  |  |  |  |  |  |  | Nepal
 |  |  |  |  |  |  |  | New Caledonia
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Occupied Palestinian Territory
 |  |  |  |  |  |  |  | Oman
 |  |  |  |  |  |  |  | Pakistan
 |  |  |  |  |  |  |  | Qatar
 |  |  |  |  |  |  |  | Réunion
 |  |  |  |  |  |  |  | Rwanda
 |  |  |  |  |  |  |  | [NAME],  [NAME] and [NAME]
 |  |  |  |  |  |  |  | Sao Tome and Principe
 |  |  |  |  |  |  |  | Saudi Arabia
 |  |  |  |  |  |  |  | Senegal
 |  |  |  |  |  |  |  | Seychelles
 |  |  |  |  |  |  |  | Sierra Leone
 |  |  |  |  |  |  |  | Somalia
 |  |  |  |  |  |  |  | South Africa
 |  |  |  |  |  |  |  | Sudan
 |  |  |  |  |  |  |  | Swaziland
 |  |  |  |  |  |  |  | Syrian Arab Republic
 |  |  |  |  |  |  |  | Togo
 |  |  |  |  |  |  |  | Tunisia
 |  |  |  |  |  |  |  | Uganda
 |  |  |  |  |  |  |  | United Arab Emirates
 |  |  |  |  |  |  |  | United Republic of Tanzania
 |  |  |  |  |  |  |  | Western Sahara
 |  |  |  |  |  |  |  | Yemen
 |  |  |  |  |  |  |  | Zambia
 |  |  |  |  |  |  |  | Zimbabwe