Forum Discussion

random163583's avatar
random163583
Occasional Reader
Mar 30, 2026

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 DateTo DateRange Title
1/1/20261/15/2026Jan 1st Half
1/16/20261/31/2026Jan 2nd Half
2/1/20262/14/2026Feb 1st Half
2/15/20262/28/2026Feb 2nd Half


Data I'd like to look up within those ranges:

From DateTo Date
1/5/20261/8/2026
2/5/20262/11/2026


Expected Results:

From DateTo DateRange
1/5/20261/8/2026Jan 1st Half
2/5/20262/11/2026Feb 1st Half


Any advice welcomed.