Automating Country Replacement

[economics]

Hey there, I'm a student working on some economics research (thus the username) I'm new here and I've been looking through the forums as of late finding some really helpful stuff, but now I'm stuck with the following predicament:

I have an excel spreadsheet with all the airplane routes that cross the world with some extraneous information, and relevant columns [Source Airport Code, Source Airport ID, Destination Airport Code, and Destination Airport ID]. Furthermore, I have a list of airports and their countries, this is what I need help with, I need to somehow make the [Airport ID, Country] be the replacement instructor. Essentially where I have Source Airport ID, it turns into the Country of that Source Airport. I need some way to have multiple inputs (all the airport ID's in a given country), and one output (the country) so that I end up with a list of country to country connections based on airplane data.

Thanks

 

[economics]

I can provide any extra information if somebody wants to help, particularly with uploading my spreadsheet and the like, also this will serve as a bump - I really do need this answered.

 

[economics]

Bump

 

[economics]

Bump

 

[economics]

Bump