Looking up, Matching, or indexing???

[Marc Enzi]

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

 

[Aladin Akyurek]

Yes, it is sorted in order on IATA

In E2 on mergeIATAdb enter:

=IF(LOOKUP(B2,paid50!A:A)=B2,LOOKUP(B2,paid50!A:B),"Not Found")