Forum Discussion
KingSachin
Feb 24, 2023Copper Contributor
If match then return the next match value but with different fields
Hi Guys,
I have a set of schedule data that shows me my inbound and outbound connections. I want to organize it in a way that in my Outbound, it shows me all my outbound connections with same airline and same sector but for the same sector there are different flight numbers ('OA Flight') and those flights also have different times for arrival and department ('OA Dep' and 'OA Arr').
I have done a VLOOKUP and it works fine by showing me my outbound connection for same airline and same sector, and where I don't have an outbound connections it shows blank. But where there are multiple different flight numbers for same sector, my VLOOKUP doesn't shows the other flights but instead it shows the same result multiple times.
Is there anyone that can kindly help please?
You can see I've highlighted in the below screenshot, for Jakarta flown by 3K, there are other flight numbers operating at different 'OA Dep' & OA Arr' time, but it only keeps showing the first match from the VLOOKUP?
Is there a way where I can formulate that if the first VLOOKUP result is same that matches my parameters (i.e. same airline code and OA Destinations as Inbound) then it should give me the next exact match (i.e. same airline code and OA Destinations) but for other 'OA Flights' and 'OA Dep' and 'OA Arr'?
- Patrick2788Silver ContributorYou'll need to use FILTER() instead of VLOOKUP to pull multiple returns for a given lookup.