Lookup Values Between Two Dates in Excel - 3 Examples

Опубликовано: 05 Май 2021
на канале: Computergaga

49,652

319

Lookup values between two dates in Excel. This video shows three examples of how to lookup between dates.

Master Excel with the Ultimate Excel course - https://bit.ly/UltimateExcel

In this video, we show two simple examples of performing a lookup between ranges of dates. We then perform a more complex lookup that includes extra criteria.

Download the sample file to follow along.
https://www.computergaga.com/_excel/f...

Here are the timings of the video.
00:00 - Introduction to the video
00:40 - Lookup between two dates with VLOOKUP
02:13 - XLOOKUP for a more durable lookup formula
03:38 - Lookup values between two dates with conditions
07:59 - Improving the lookup formula

Find more great free tutorials at;
https://www.computergaga.com

** Online Excel Courses **

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ►   / 18737946
Instagram ►   / computergaga1
Twitter ►   / computergaga1