📅Excel Lookup By Date | If Date is Between Two Dates then Return Value | If Date is Between Range

In this Excel video tutorial I demonstrate how to lookup a date in multiple dates ranges and return an associated value. In my example, I have percentage rates that relate to date ranges. I want to be able to pick a date and find out which rate applies. How you achieve this very much depends on the layout of the lookup table of rates.

✔️00:00 Introduction
✔️00:57 Layout 1: VLOOKUP approximate match
✔️02:26 Layout 2: FILTER function (Excel 365)
✔️04:05 Layout 2: INDEX and MATCH (all versions of Excel)

#exceltutorial #exceltips #excel365

[katiemurray]

I was racking my brain this morning. Thank you so much! Saved me so much time!

[iliachechenev]

My god, you have saved my nerve with the Filter formula, Thanks! The side effect of it - you will see if you have date duplicates or crossing dates in the array.

[dmuhlarik]

Perfect. Exactly what I needed. It worked exactly right.

[IvanCortinas_ES]

Excellent turorial Chester. Thank you!!!

[Otto-Webb]

i worked with "if and" before, this way cut the formula by 2/3s. thanks fella!

[estephanina]

For the older version, could you also do an If And statemet?

[pctLowBattery]

Awesome 🤩 does take a little bit to “calculate”

[kurtnijs]

Can u use the same reasoning if u want to apply this to DAX?

[arunknarayan]

Hey, Can you explain how to find the SUM using the same formula rather than finding the Rate%

[vijaydagar]

How to use these functions with vlookup for to find out particular items+nearest date from another table.