I’m trying to pull Routes based on whether the date is within a certain range.
I want to pull column M and fill column D based on these conditions:
Column K is between or equal to columns B and C
Based on things I have seen on the internet, I figured an array formula with INDEX/MATCH would be the best method, but so far have been rather stumped by this. the full sheet is much larger I have just made a smaller sample size to figure out the needed formula. Any help would be greatly appreciated.
Image is of the data I have:
