Spreadsheet: 771661d1646775064-help-extract-country-values-from-a-list-that-contains-address-info-excelquestionworkbook
Sheet: Sheet1

[NAME] | Country |  |  |  | Country List (lookup)?
# 12-05, SINGAPORE 237 973 |  |  |  |  | United States
# 7 - 31 OFI 205 |  |  |  |  | Canada
#04-1632, SINGAPORE 600336 |  |  |  |  | Afghanistan
#09-01,SINGAPORE 068909 |  |  |  |  | Aland Islands
#12-05, SINGAPORE 237973 |  |  |  |  | Albania
#1C-47 BARQUISIMETO VENEZUELA |  |  |  |  | Algeria
#1LOS CHORROS CCS VENEZUELA 1071 |  |  |  |  | American Samoa
#25-08, 068809, SINGAPORE |  |  |  |  | Andorra
#25-08, 068809, SINGAPORE |  |  |  |  | Angola
#25-08, 068809, SINGAPORE |  |  |  |  | Anguilla
#25-08, 068809, SINGAPORE&#8195; |  |  |  |  | Antarctica
#N-4899 NASSAU BAHAMAS |  |  |  |  | [NAME] and [NAME]
(11507) MOTEVIDEO, URUGUAY |  |  |  |  | Argentina
(11800) MONTEVIDEO URUGUAY |  |  |  |  | Armenia
(B1605EHD) MUNRO, ARGENTINA |  |  |  |  | Aruba
(C 1430 ENA) ARGENTINA |  |  |  |  | Ascension Island
(QUISQUEYA) SANTO DOMINGO |  |  |  |  | Australia
00178 ROME ITALY |  |  |  |  | Austria
004 BRAZIL |  |  |  |  | Azerbaijan
00950 POLAND |  |  |  |  | Bahamas
00950 POLAND |  |  |  |  | Bahrain
00950 POLAND |  |  |  |  | Bangladesh
00950 POLAND |  |  |  |  | Barbados
01061 VENEZUELA |  |  |  |  | Belarus
 |  |  |  |  | Belgium
 |  |  |  |  | Belize
 |  |  |  |  | Benin
 |  |  |  |  | Bermuda
 |  |  |  |  | Bhutan
 |  |  |  |  | Bolivia
 |  |  |  |  | Bosnia
 |  |  |  |  | Botswana
 |  |  |  |  | Bouvet Island
 |  |  |  |  | Brazil
 |  |  |  |  | British Indian Ocean Territory
 |  |  |  |  | [NAME]
 |  |  |  |  | Bulgaria
 |  |  |  |  | [NAME]
 |  |  |  |  | Burundi
 |  |  |  |  | Cambodia
 |  |  |  |  | Cameroon
 |  |  |  |  | Cape Verde
 |  |  |  |  | Caribbean Netherlands
 |  |  |  |  | Cayman Islands
 |  |  |  |  | Central African Republic
 |  |  |  |  | Chad
 |  |  |  |  | Chile
 |  |  |  |  | China
 |  |  |  |  | Christmas Island
 |  |  |  |  | Cocos (Keeling) Islands
 |  |  |  |  | Colombia
 |  |  |  |  | Comoros
 |  |  |  |  | Congo
 |  |  |  |  | DR Congo
 |  |  |  |  | Cook Islands
 |  |  |  |  | Costa Rica
 |  |  |  |  | Côte d'Ivoire
 |  |  |  |  | Croatia
 |  |  |  |  | Cuba
 |  |  |  |  | Curaçao
 |  |  |  |  | Cyprus
 |  |  |  |  | Czech Republic
 |  |  |  |  | Denmark
 |  |  |  |  | Djibouti
 |  |  |  |  | Dominica
 |  |  |  |  | Dominican Republic
 |  |  |  |  | Ecuador
 |  |  |  |  | Egypt
 |  |  |  |  | El Salvador
 |  |  |  |  | Equatorial Guinea
 |  |  |  |  | Eritrea
 |  |  |  |  | Estonia
 |  |  |  |  | Ethiopia
 |  |  |  |  | Falkland Islands
 |  |  |  |  | Faroe Islands
 |  |  |  |  | Fiji
 |  |  |  |  | Finland
 |  |  |  |  | France
 |  |  |  |  | French [NAME]
 |  |  |  |  | French Polynesia
 |  |  |  |  | French Southern Territories
 |  |  |  |  | Gabon
 |  |  |  |  | Gambia
 |  |  |  |  | Georgia
 |  |  |  |  | Germany
 |  |  |  |  | Ghana
 |  |  |  |  | Gibraltar
 |  |  |  |  | Greece
 |  |  |  |  | Greenland
 |  |  |  |  | Grenada
 |  |  |  |  | Guadeloupe
 |  |  |  |  | Guam
 |  |  |  |  | Guatemala
 |  |  |  |  | Guernsey
 |  |  |  |  | Guinea
 |  |  |  |  | Guinea-Bissau
 |  |  |  |  | Guyana
 |  |  |  |  | Haiti
 |  |  |  |  | Honduras
 |  |  |  |  | Hong Kong
 |  |  |  |  | Hungary
 |  |  |  |  | Iceland
 |  |  |  |  | India
 |  |  |  |  | Indonesia
 |  |  |  |  | Iran
 |  |  |  |  | Iraq
 |  |  |  |  | Ireland
 |  |  |  |  | Isle of Man
 |  |  |  |  | Israel
 |  |  |  |  | Italy
 |  |  |  |  | Jamaica
 |  |  |  |  | Japan
 |  |  |  |  | Jersey
 |  |  |  |  | Jordan
 |  |  |  |  | Kazakhstan
 |  |  |  |  | Kenya
 |  |  |  |  | Kiribati
 |  |  |  |  | Kuwait
 |  |  |  |  | Kyrgyzstan
 |  |  |  |  | Lao
 |  |  |  |  | Latvia
 |  |  |  |  | Lebanon
 |  |  |  |  | [NAME]
 |  |  |  |  | Liberia
 |  |  |  |  | Libya
 |  |  |  |  | [NAME]
 |  |  |  |  | Lithuania
 |  |  |  |  | Luxembourg
 |  |  |  |  | Macao
 |  |  |  |  | Macedonia
 |  |  |  |  | Madagascar
 |  |  |  |  | [NAME]
 |  |  |  |  | Malaysia
 |  |  |  |  | Maldives
 |  |  |  |  | [NAME]
 |  |  |  |  | Malta
 |  |  |  |  | Marshall Islands
 |  |  |  |  | Martinique
 |  |  |  |  | Mauritania
 |  |  |  |  | [NAME]
 |  |  |  |  | Mayotte
 |  |  |  |  | Mexico
 |  |  |  |  | [NAME]
 |  |  |  |  | Moldova
 |  |  |  |  | Monaco
 |  |  |  |  | Mongolia
 |  |  |  |  | Montenegro
 |  |  |  |  | Montserrat
 |  |  |  |  | Morocco
 |  |  |  |  | Mozambique
 |  |  |  |  | Myanmar
 |  |  |  |  | Namibia
 |  |  |  |  | Nauru
 |  |  |  |  | Nepal
 |  |  |  |  | Netherlands
 |  |  |  |  | New Caledonia
 |  |  |  |  | New Zealand
 |  |  |  |  | Nicaragua
 |  |  |  |  | [NAME]
 |  |  |  |  | Nigeria
 |  |  |  |  | Niue
 |  |  |  |  | Norfolk Island
 |  |  |  |  | Northern Mariana Islands
 |  |  |  |  | North Korea
 |  |  |  |  | Norway
 |  |  |  |  | Oman
 |  |  |  |  | Pakistan
 |  |  |  |  | Palau
 |  |  |  |  | Palestinian Territory
 |  |  |  |  | Panama
 |  |  |  |  | [NAME]
 |  |  |  |  | Paraguay
 |  |  |  |  | Peru
 |  |  |  |  | Philippines
 |  |  |  |  | Pitcairn
 |  |  |  |  | Poland
 |  |  |  |  | Portugal
 |  |  |  |  | Puerto Rico
 |  |  |  |  | Qatar
 |  |  |  |  | Réunion
 |  |  |  |  | Romania
 |  |  |  |  | Russian Federation
 |  |  |  |  | Rwanda
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME] Nevis
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME] and Miquelon
 |  |  |  |  | Saint Vincent and the Grenadines
 |  |  |  |  | Samoa
 |  |  |  |  | [NAME]
 |  |  |  |  | Sao Tome and Principe
 |  |  |  |  | Saudi Arabia
 |  |  |  |  | Senegal
 |  |  |  |  | Serbia
 |  |  |  |  | Seychelles
 |  |  |  |  | Sierra Leone
 |  |  |  |  | Singapore
 |  |  |  |  | Sint Maarten
 |  |  |  |  | Slovakia
 |  |  |  |  | Slovenia
 |  |  |  |  | Solomon Islands
 |  |  |  |  | Somalia
 |  |  |  |  | South Africa
 |  |  |  |  | South Korea
 |  |  |  |  | South Sudan
 |  |  |  |  | Spain
 |  |  |  |  | [NAME]
 |  |  |  |  | Sudan
 |  |  |  |  | Suriname
 |  |  |  |  | [NAME] and [NAME]
 |  |  |  |  | Swaziland
 |  |  |  |  | Sweden
 |  |  |  |  | Switzerland
 |  |  |  |  | Syrian Arab Republic
 |  |  |  |  | Taiwan
 |  |  |  |  | Tajikistan
 |  |  |  |  | Tanzania
 |  |  |  |  | Thailand
 |  |  |  |  | Timor-Leste
 |  |  |  |  | Togo
 |  |  |  |  | Tokelau
 |  |  |  |  | Tonga
 |  |  |  |  | Trinidad and Tobago
 |  |  |  |  | [NAME]
 |  |  |  |  | Tunisia
 |  |  |  |  | Turkey
 |  |  |  |  | Turkmenistan
 |  |  |  |  | Turks and Caicos Islands
 |  |  |  |  | Tuvalu
 |  |  |  |  | Uganda
 |  |  |  |  | Ukraine
 |  |  |  |  | United Arab Emirates
 |  |  |  |  | United Kingdom
 |  |  |  |  | US Minor Outlying Islands
 |  |  |  |  | Uruguay
 |  |  |  |  | Uzbekistan
 |  |  |  |  | [NAME]
 |  |  |  |  | Vatican City
 |  |  |  |  | Venezuela
 |  |  |  |  | Viet Nam
 |  |  |  |  | Virgin Islands, British
 |  |  |  |  | Virgin Islands, U.S.
 |  |  |  |  | [NAME]
 |  |  |  |  | Western Sahara
 |  |  |  |  | Yemen
 |  |  |  |  | Zambia
 |  |  |  |  | Zimbabwe