Forum Discussion
random163583
Mar 30, 2026Occasional Reader
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 also have a list of established date ranges, each titled. I would like to look up each of my date ranges to find if they fall witin any of the date ranges from the list and then pull in the appropriate date range title.
Example:
List of established date ranges:
| From Date | To Date | Range Title |
| 1/1/2026 | 1/15/2026 | Jan 1st Half |
| 1/16/2026 | 1/31/2026 | Jan 2nd Half |
| 2/1/2026 | 2/14/2026 | Feb 1st Half |
| 2/15/2026 | 2/28/2026 | Feb 2nd Half |
Data I'd like to look up within those ranges:
| From Date | To Date |
| 1/5/2026 | 1/8/2026 |
| 2/5/2026 | 2/11/2026 |
Expected Results:
| From Date | To Date | Range |
| 1/5/2026 | 1/8/2026 | Jan 1st Half |
| 2/5/2026 | 2/11/2026 | Feb 1st Half |
Any advice welcomed.
1 Reply
- Harun24HRSilver Contributor
You may try the following formula-
=@FILTER($C$2:$C$5,($A$2:$A$5<=$F4)*($B$2:$B$5>=$G4),"")