Vlookup functions for airport codes

[cchueh]

Hello,

I want to build in airport codes from my second tab to my first tab's information. Please see below:

Original File: 

Preferred Outcome:

I have the airport codes in the second tab "Airport Code"

Even if we can break out the airport code into multiple columns as long as it indicates which from and to airport location it is , I would really appreciate it!!

Thank you!

[DavidP]

This is how I would do it. Have a look if it works for you, or let me know if you'd like to change something.

I basically duplicate the route field for each flight and then use find replace to replace each code with the airport name.

The initial airport code fields are created manually, but we can make this dynamic as well if needed.

[DavidP · Accepted solution]

Here is an updated version of the workflow where the Airport code fields are dynamically created.

[cchueh]

@DavidP  Thank you so much, this works! Really appreciate it!