Filter Function based on a date nested in Xlookup

[willtways]

Hi,

See attached a sample job scheduling dataset. I need to lookup the bay # and return the job # which is simple enough with an xlookup. However, there will be multiple jobs with the same bay # and I need a way to be able to only pull the job number that starts after a certain date. I would think using the filter function with the xlookup function would work, but I am unable to get it to do so. Any help in getting the formula in D19 to return job number 8005 and not 8000 or an error would be very helpful.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Filter Function based on a date nested in Xlookup
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Fluff]

How about

=TAKE(FILTER(Schedule[Job '#],(Schedule[Bay '#]=B19)*(Schedule[Phase 60]>=B13)),1)