I am compiling a list of Countries and Airports from different sources. I am trying to get the Country Code from one list to Match Up with the Country.
I am a novice and this is a bit out of my grasp.
Here is an excerpt from the list of Airports
Airport.......Code.............Country Name....Country Code
Aarhus...........AAR..............Denmark........... ?
Aberdeen.......ABZ...............UK................... ?
Aberdeen, SD.ABR...............USA................. ?
Here is an excerpt from the Country List
Country List....................Country Codes List
ALBANIA.............................AL
Denmark............................DK
ANGOLA..............................AO
ANGUILLA...........................AI
UAE...................................AE
UK.....................................GB
USA...................................US
My goal is to have the Country Code Come Up at the far right in the 1st table above given a particular Country Name...
Thanks
I am a novice and this is a bit out of my grasp.
Here is an excerpt from the list of Airports
Airport.......Code.............Country Name....Country Code
Aarhus...........AAR..............Denmark........... ?
Aberdeen.......ABZ...............UK................... ?
Aberdeen, SD.ABR...............USA................. ?
Here is an excerpt from the Country List
Country List....................Country Codes List
ALBANIA.............................AL
Denmark............................DK
ANGOLA..............................AO
ANGUILLA...........................AI
UAE...................................AE
UK.....................................GB
USA...................................US
My goal is to have the Country Code Come Up at the far right in the 1st table above given a particular Country Name...
Thanks