Spreadsheet: 189660d1351270592-matching-a-cell-against-a-pre-defined-table-and-returning-an-adjacent-cell-as-a-result-test-sheet_1
Sheet: Sheet1

Afghanistan | AF | SOUTH AFRICA
Albania | AL | MEXICO
Algeria | BAI | PERU
American Samoa | AS | RUSSIA
Andorra | AD | DOMINICAN REP
Angola | AO | UAE
Antarctica | AQ | BRAZIL
Antigua | AG | EUROZONE
Argentina | AR | KAZAKHSTAN
[NAME] | AW | RUSSIA
Austraclear New Zealand | XZ | PERU
[NAME] | AT | BRAZIL
Azerbaijan | AZ | SINGAPORE
Bahamas | BBH | INDONESIA
Bahrain | BBJ | INDONESIA
Bangladesh | BBW | ARGENTINA
Barbados | BB | BRAZIL
Belgium | BBE | BRAZIL
Belize | BZ | BRAZIL
Bermuda | BBD | JAMAICA
Bhutan | BT | BRAZIL
Bolivia | BO | HONG KONG
Botswana | BBO | RUSSIA
Bouvet Island | BV | HONG KONG
Brazil | BBZ | CHINA
Australia | AU | DOMINICAN REP
British Indian Ocean Territory | IO | INDONESIA
British Virgin Islands | BVS | ARGENTINA
Brunei | BBM | QATAR
Bulgaria | BBP | INDONESIA
[NAME] | BU | CHINA
Burundi | BI | MEXICO
[NAME] | BY | BARBADOS
Cameroon | CM | UKRAINE
Canada | BCA | CHILE
Canton And Enderbury Islands | CT | CHINA
Cape Verde | BCV | UNITED STATES
Cayman Islands | BCI | UAE
Central African Republic | BCF | KAZAKHSTAN
Chad | TD | BRAZIL
Channel Islands | BCS | QATAR
Chile | BCL | CHINA
China | BCH | INDIA
Christmas Island | CX | CHINA
Cocos (Keeling) Islands | CC | JAMAICA
Columbia | [NAME] | CHINA
Comoros | KM | COLOMBIA
Congo | CG | UAE
Cook Islands | BOI | UKRAINE
Costa Rica | BCR | SOUTH AFRICA
Croatia | BHR | TURKEY
Cuba | BCU | ARGENTINA
Cyprus | BCC | SOUTH KOREA
Czech Republic | BCZ | MEXICO
Czechoslovakia | CS | UK
Denmark | BDE | MEXICO
Djibouti | DJ | BRAZIL
Dominica | DM | BRAZIL
Dominican Republic | BDR | UAE
[NAME] | NQ | JAMAICA
East Timor | TP | BRAZIL
Ecuador | BED | SINGAPORE
Egypt | BEG | INDIA
El Salvador | BEL | ARGENTINA
Estonia | BEE | UKRAINE
Faeroe Islands | FO | BRAZIL
Falkland Islands (Malvinas) | FK | UAE
Fiji | BFJ | KAZAKHSTAN
Finland | BFI | INDONESIA
France | BFR | PERU
Free Of Tax | [NAME] | BRAZIL
French [NAME] | GF | CHINA
French [NAME] | PF | UAE
Gabon | GA | INDIA
Gambia | GM | PERU
Georgia | BGG | RUSSIA
German Democratic Republic | DD | RUSSIA
Germany | BGE | BRAZIL
Equatorial Guinea | [NAME] | BRAZIL
Ghana | BGH | RUSSIA
Gibraltar | BGI | BRAZIL
Greece | BGR | RUSSIA
Greenland | GL | RUSSIA
Grenada | GD | INDONESIA
Guadeloupe | GP | SAUDI ARABIA
Guam | GU | BRAZIL
Guatemala | BGU | RUSSIA
Guinea | GN | RUSSIA
Guinea-Bissau | GW | INDIA
Guyana | GY | CHINA
Haiti | HT | ARGENTINA
Heard And Mcdonald Islands | HM | BRAZIL
Honduras | HN | MEXICO
Hong Kong | BHK | BRAZIL
Hungary | BHU | MEXICO
Iceland | BIC | INDONESIA
India | BIN | CHINA
Indonesia | BID | CHINA
Iran | BIA | MEXICO
Iraq | BIQ | CHINA
Ireland | BIE | CHILE
Isle Of Man | BIO | BRAZIL
Israel | BIS | MEXICO
Italy | BIT | BRAZIL
Ivory Coast | BIV | COLOMBIA
Jamaica | BJM | MEXICO
Japan | BJN | UAE
Jersey Channel | BJE | MEXICO
Johnston Island | JT | BRAZIL
Jordan | BJO | INDONESIA
[NAME] | KH | UAE
Kazakhstan | BKZ | COLOMBIA
Kenya | BKN | CHINA
Kiribati | KI | ARGENTINA
Korea | BSK | INDIA
Kuwait | BKU | RUSSIA
Lao Peoples Democratic Republi | LA | SINGAPORE
Laos | BLO | RUSSIA
Latvia | BLL | MEXICO
Lebanon | BLB | BRAZIL
Liberia | LR | UAE
Libyan Arab Jamahiriya | LY | COLOMBIA
[NAME] | BLI | UAE
Lithuania | [NAME] | BRAZIL
Luxembourg | BLX | MONGOLIA
Macau | BU2 | JAMAICA
Madagascar | MG | BRAZIL
[NAME] | MW | CHINA
Malaysia | BMA | COLOMBIA
Maldives | MV | CHINA
[NAME] | ML | SOUTH KOREA
Malta | BMB | UKRAINE
Marshall Islands | MH | HONG KONG
Martinique | MQ | NIGERIA
Mauritania | MR | UAE
Mauritius | BMP | UAE
Mexico | BMX | BRAZIL
[NAME] | FM | RUSSIA
Midway Islands | MI | UAE
Moldova | BMK | BRAZIL
Monaco | BMQ | INDIA
Mongolia | BMJ | SAUDI ARABIA
[NAME] | [NAME] | UAE
Morocco | BMO | RUSSIA
Mozambique | BMZ | INDONESIA
Namibia | BNA | SOUTH KOREA
Nauru | NR | BRAZIL
Nepal | NP | UAE
Netherlands | BNE | BRAZIL
Netherlands Antilles | AN | CHINA
Neutral Zone | NT | UAE
New Caledonia | [NAME] | INDIA
New Zealand | BNZ | HONG KONG
Nicaragua | BNC | BRAZIL
Niger | NE | BRAZIL
Nigeria | NG | SOUTH KOREA
Niue | NU | MEXICO
Norfolk Island | NF | PERU
Norway | NO | UAE
Oman | BOM | CHINA
Pacific Islands | PC | MEXICO
Pakistan | BPK | INDONESIA
Palau | PW
Panama | BPN
[NAME] | BPP
Paraguay | BPG
Peru | BPE
Philippines | BPH
Pitcairn Island | PN
Poland | BPD
Portugal | BPO
Puerto Rico | BPR
Qatar | BQA
Reunion | RE
Romania | PRO
Russia | BRU
Rwanda | RW
[NAME] | LC
Saint Vincent And Grenadines | [NAME]
Samoa | WS
[NAME] | SM
Sao Tome And Principe | ST
Saudi Arabia | BSR
Scotland | BSC
Senegal | SN
Serbia & Montenegro | BYV
Seychelles | BEY
Sierra Leone | SL
Singapore | BSI
Slovakia | BSO
Slovenia | BSV
[NAME] | SB
Somalia | BSQ
South Africa | BA9
Spain | BSP
Sri Lanka | BSL
St. Kitts-Nevis-Anguilla | KN
St.Helena | SH
St.Pierre And Miquelon | PM
Sudan | BSD
Supranational | BSNAT
Suriname | SR
[NAME] And [NAME] | SJ
Swaziland | SZ
Sweden | BSW
Switzerland | BSZ
Syrian Arab Republic | BSY
Taiwan | BTA
Tajikistan | BTJ
Tanzania | TZ
Thailand | TH
Timor-Leste | BTI
Togo | TG
Tokelau | TK
Tonga | TO
Trinidad And Tobago | BTR
Tunisia | BTN
Turkey | BTU
[NAME] | BTT
Turks And Caicos Islands | TC
Tuvalu | TV
[NAME]. Pacific Islands | PU
Uganda | BUG
Ukraine | BUK
United Arab Emirates | AE
United Kingdom | BGB
United States | US
United States Virgin Islands | BVG
Unknown | XX
Upper Volta | HV
Uruguay | BUR
Uzbekistan | BUZ
[NAME] | VU
Vatican City State (Holy See) | VA
Venezuela | BVZ
Vietnam | BVN
Wake Island | WK
Wales | BWA
[NAME] | WF
Western Sahara | EH
Yemen | YE
Yugoslavia | YU
Zaire | ZR
Zambia | BZM
Zimbabwe | BZI