Lookup to find closest date and time using lookup table

I am trying to find out a way in which to match all inbound flights for DFW & SFO to the nearest outbound flights from the lookup table while returning the outbound flt_nbr, flt_date flt_day and time. I have attached the sample inbound and lookup table. Any assistance would be greatly appreciated.

Inbound Table.xlsx

Lookup Table.xlsx

Preparation

Accepted answers

NicoleJohnson

Try something like the attached!

Basic philosophy is to join your Lookup Table to the Inbound data (by Arrival city = Departure city), calculate the time between flights, filter out anything leaving before the inbound flight arrives (time between flights is a negative number), and then choosing the outbound flight with the shortest amount of time between arrival time and departure time.

Hope that helps!

Cheers,

FlightScenario.yxmd

All comments

NicoleJohnson

Try something like the attached!

Hope that helps!

Cheers,

FlightScenario.yxmd

QVC

Thank you Nicole!! This is exactly what I was looking for.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703