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

Download the featured file here: www.bluepecantraining.com/wp-...
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

[@iliachechenev1346]

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.

[@IvanCortinas_ES]

Excellent turorial Chester. Thank you!!!

[@stevereed5776]

Very useful Chester, thank you

[@Otto-Webb]

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

[@5pctLowBattery]

Awesome 🤩 does take a little bit to “calculate”

[@estephanina]

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

[@kurtnijs2213]

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

[@vijaydagar8519]

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

[@muhammadimranbukhari9557]

Filter function add in file