Spreadsheet: 40786d1239186152-taking-an-index-match-function-one-step-further-example
Sheet: Sheet3

Country Name | UN/ISO
AFGHANISTAN | 4
ALBANIA | 8
ANTARCTICA | 10
ALGERIA (El Djazaïr) | 12
AMERICAN SAMOA | 16
ANDORRA | 20
ANGOLA | 24
ANTIGUA AND BARBUDA | 28
AZERBAIJAN | 31
ARGENTINA | 32
AUSTRALIA | 36
AUSTRIA | 40
BAHAMAS | 44
BAHRAIN | 48
BANGLADESH | 50
ARMENIA | 51
BARBADOS | 52
BELGIUM | 56
BERMUDA | 60
BHUTAN | 64
[NAME] | 68
BOSNIA AND HERZEGOVINA | 70
BOTSWANA | 72
BOUVET ISLAND | 74
BRAZIL | 76
BELIZE | 84
BRITISH INDIAN OCEAN TERRITORY | 86
SOLOMON ISLANDS | 90
[NAME], BRITISH | 92
BRUNEI DARUSSALAM | 96
BULGARIA | 100
MYANMAR (formerly Burma) | 104
BURUNDI | 108
BELARUS | 112
CAMBODIA | 116
CAMEROON | 120
CANADA | 124
CAPE VERDE | 132
CAYMAN ISLANDS | 136
CENTRAL AFRICAN REPUBLIC | 140
SRI LANKA (formerly Ceylon) | 144
CHAD (Tchad) | 148
CHILE | 152
CHINA | 156
TAIWAN ("Chinese Taipei" for IOC) | 158
CHRISTMAS ISLAND | 162
COCOS (KEELING) ISLANDS | 166
COLOMBIA | 170
COMOROS | 174
MAYOTTE | 175
CONGO, REPUBLIC OF | 178
CONGO | 180
COOK ISLANDS | 184
COSTA RICA | 188
CROATIA (Hrvatska) | 191
CUBA | 192
CYPRUS | 196
CZECH REPUBLIC | 203
BENIN | 204
DENMARK | 208
DOMINICA | 212
DOMINICAN REPUBLIC | 214
ECUADOR | 218
EL SALVADOR | 222
EQUATORIAL GUINEA | 226
ETHIOPIA | 231
ERITREA | 232
ESTONIA | 233
FAEROE ISLANDS | 234
FALKLAND ISLANDS (MALVINAS) | 238
SOUTH GEORGIA | 239
FIJI | 242
FINLAND | 246
ÅLAND ISLANDS | 248
FRANCE | 250
FRENCH GUIANA | 254
FRENCH POLYNESIA | 258
FRENCH SOUTHERN TERRITORIES | 260
DJIBOUTI | 262
GABON | 266
GEORGIA | 268
GAMBIA, THE | 270
PALESTINIAN TERRITORIES | 275
GERMANY (Deutschland) | 276
GHANA | 288
GIBRALTAR | 292
KIRIBATI | 296
GREECE | 300
[NAME] | 304
GRENADA | 308
GUADELOUPE | 312
GUAM | 316
GUATEMALA | 320
GUINEA | 324
GUYANA | 328
HAITI | 332
HEARD ISLAND AND MCDONALD ISLANDS | 334
VATICAN CITY (Holy See) | 336
HONDURAS | 340
HONG KONG | 344
HUNGARY | 348
ICELAND | 352
INDIA | 356
INDONESIA | 360
IRAN (Islamic Republic of Iran) | 364
IRAQ | 368
IRELAND | 372
ISRAEL | 376
ITALY | 380
CÔTE D'IVOIRE (Ivory Coast) | 384
JAMAICA | 388
JAPAN | 392
KAZAKHSTAN | 398
JORDAN | 400
KENYA | 404
KOREA | 408
KOREA (Republic of [South] Korea) | 410
KUWAIT | 414
KYRGYZSTAN | 417
LAO PEOPLE'S DEMOCRATIC REPUBLIC | 418
LEBANON | 422
LESOTHO | 426
LATVIA | 428
LIBERIA | 430
LIBYA (Libyan Arab Jamahirya) | 434
LIECHTENSTEIN (Fürstentum Liechtenstein) | 438
LITHUANIA | 440
LUXEMBOURG | 442
MACAO | 446
MADAGASCAR | 450
MALAWI | 454
MALAYSIA | 458
[NAME] | 462
MALI | 466
MALTA | 470
MARTINIQUE | 474
MAURITANIA | 478
MAURITIUS | 480
MEXICO | 484
MONACO | 492
MONGOLIA | 496
MOLDOVA | 498
MONTENEGRO | 499
MONTSERRAT | 500
MOROCCO | 504
MOZAMBIQUE (Moçambique) | 508
OMAN | 512
NAMIBIA | 516
NAURU | 520
NEPAL | 524
NETHERLANDS | 528
NETHERLANDS ANTILLES | 530
ARUBA | 533
NEW CALEDONIA | 540
VANUATU | 548
NEW ZEALAND | 554
NICARAGUA | 558
NIGER | 562
NIGERIA | 566
NIUE | 570
NORFOLK ISLAND | 574
NORWAY | 578
NORTHERN MARIANA ISLANDS | 580
UNITED STATES MINOR OUTLYING ISLANDS | 581
MICRONESIA | 583
MARSHALL ISLANDS | 584
PALAU | 585
PAKISTAN | 586
PANAMA | 591
PAPUA NEW GUINEA | 598
PARAGUAY | 600
PERU | 604
PHILIPPINES | 608
PITCAIRN | 612
POLAND | 616
PORTUGAL | 620
GUINEA-BISSAU | 624
TIMOR-LESTE (formerly East Timor) | 626
PUERTO RICO | 630
QATAR | 634
RÉUNION | 638
ROMANIA | 642
RUSSIAN FEDERATION | 643
RWANDA | 646
[NAME] | 652
[NAME] | 654
[NAME] AND NEVIS | 659
ANGUILLA | 660
[NAME] LUCIA | 662
[NAME] (French portion) | 663
[NAME] AND MIQUELON | 666
[NAME] AND THE GRENADINES | 670
SAN MARINO (Republic of) | 674
SAO TOME AND PRINCIPE | 678
SAUDI ARABIA | 682
SENEGAL | 686
SERBIA (Republic of Serbia) | 688
SEYCHELLES | 690
SIERRA LEONE | 694
SINGAPORE | 702
SLOVAKIA (Slovak Republic) | 703
VIET NAM | 704
SLOVENIA | 705
SOMALIA | 706
SOUTH AFRICA | 710
ZIMBABWE | 716
SPAIN (España) | 724
WESTERN SAHARA | 732
SUDAN | 736
SURINAME | 740
SVALBARD AND JAN MAYEN | 744
[NAME] | 748
SWEDEN | 752
SWITZERLAND | 756
SYRIAN ARAB REPUBLIC | 760
TAJIKISTAN | 762
THAILAND | 764
TOGO | 768
TOKELAU | 772
TONGA | 776
TRINIDAD AND TOBAGO | 780
UNITED ARAB EMIRATES | 784
TUNISIA | 788
TURKEY | 792
TURKMENISTAN | 795
TURKS AND CAICOS ISLANDS | 796
TUVALU | 798
UGANDA | 800
UKRAINE | 804
MACEDONIA | 807
EGYPT | 818
UK | 826
UNITED KINGDOM (Great Britain) | 826
CHANNEL ISLANDS | 830
ISLE OF MAN | 833
TANZANIA | 834
UNITED STATES | 840
[NAME], U.S. | 850
BURKINA FASO | 854
URUGUAY | 858
UZBEKISTAN | 860
VENEZUELA | 862
WALLIS AND FUTUNA | 876
SAMOA (formerly Western Samoa) | 882
YEMEN (Yemen Arab Republic) | 887
ZAMBIA | 894
ALDERNEY
[NAME]
EUROPEAN UNION
GUERNSEY
INTERNATIONAL ORGANIZATIONS
JERSEY
SOVIET UNION (Internet code still used)
TANGANYIKA
YUGOSLAVIA (Internet code still used)
ZANZIBAR