Vlookup functions for airport codes

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!

Flight.xlsx

Datasets

Developer

Output

Parse

Fuzzy Match

Preparation

Calgary

Accepted answers

DavidP

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

match airport code 2.yxmd

All comments

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.

match airport code.yxmd

DavidP

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

match airport code 2.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703