![]() ![]()
Step 5: Repeat VLOOKUPs to add in latitude, longitude, city, country columns and merge back with DFID dataĪfter I got all of the airport codes, I used those as the basis for a VLOOKUP to pull all latitude, longitude, city and country data into our spreadsheet as well.įinally, I used the VLOOKUP code back in our DFID flights spreadsheet to lookup departure and destination information. Big cities may have more than one airport, and the lookup will pull whichever one it finds first. It's also worth noting that, if you're using the city as the lookup value, we need to be careful.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |