Forum Discussion
random163583
Mar 30, 2026Copper Contributor
Look up a date range and return title from list of date ranges it falls within?
I searched and didn't quite find this answer, hoping somebody can help. I would say I'm a novice with Excel, but can generally follow directions well enough. I have a list of from and to dates. I al...
Harun24HR
Mar 31, 2026Silver Contributor
You may try the following formula-
=@FILTER($C$2:$C$5,($A$2:$A$5<=$F4)*($B$2:$B$5>=$G4),"")