kangelosanto
New Member
- Joined
- Aug 12, 2014
- Messages
- 14
So here's a quick overview of what I need:
On one sheet (let's call this "SHEET A") I have a list of every airport in the world and the following data:
<tbody>
</tbody>
I have another table on another sheet (let's call this "SHEET B") with every country in the world, and then in the cell next to it a unique number (i.e. Afghanistan | 1, Albania | 2, etc.)
I figured in theory I could run some sort of variation of an INDEX(MATCH that would search using the country on Sheet B (such as *Australia* or *France*), find it in column 4 of Sheet A, and then fill in the missing country code field from Sheet B in Column 7 of Sheet A.
Any help is appreciated!
On one sheet (let's call this "SHEET A") I have a list of every airport in the world and the following data:
IATA | ICAO | Airport Name | Location Serverd | Time | DST | Country Code |
AAA | NTQA | Anaa Airport | Anaa, Tuamotus, French Polynesia | UTC | ||
AAB | YARY | Arrabury | Arrabury, Queensland, Australia | UTC |
<tbody>
</tbody>
I have another table on another sheet (let's call this "SHEET B") with every country in the world, and then in the cell next to it a unique number (i.e. Afghanistan | 1, Albania | 2, etc.)
I figured in theory I could run some sort of variation of an INDEX(MATCH that would search using the country on Sheet B (such as *Australia* or *France*), find it in column 4 of Sheet A, and then fill in the missing country code field from Sheet B in Column 7 of Sheet A.
Any help is appreciated!