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

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! 👍👍
Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/10/Lookup-a-value-if-it-falls-between-two-dates.xlsx

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

Видео 📅Excel Lookup By Date | If Date is Between Two Dates then Return Value | If Date is Between Range канала Chester Tugwell