Forum Discussion

random163583's avatar
random163583
Copper Contributor
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 al...
excel
Formulas and Functions
IlirU's avatar
IlirU
Iron Contributor
Apr 01, 2026

Hi random163583​,

If you want to use a dynamic formula, then the formula given by Harun24HR can be transformed into this formula:

=VSTACK("Range", MAP(E2:E3, F2:F3, LAMBDA(a,b, FILTER(C2:C5, (a >= A2:A5) * (b <= B2:B5)))))

I have applied this formula in cell G1 (see screenshot above).

HTH

IlirU