Lookup Values Between Two Dates in Excel - 3 Examples

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 - 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.
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;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1

[@IvanCortinas_ES]

Excellent the last part. Surely I would have missed the final correction! Thank you Alan!

[@Computergaga]

Thank you, Iván.

[@excel_along_the_way]

Thanks Alan, really appreciate that last part. Opens a whole new way of looking up things.

[@wolfvonderr4487]

This is such an amazing solution. Thank you for an exemplary video!

[@Computergaga]

You're very welcome!

[@patrickschardt7724]

Thanks for sharing your knowledge

[@Computergaga]

No problem, Patrick 👍

[@jayantkumarjoshi270]

Superb...👌
In-depth explanation with practical use-cases.
Thanks a lot. 🤝🙂

[@Computergaga]

Most welcome, Jayantkumar 😊

[@tobayekaina8610]

Thanks for sharing

[@Computergaga]

My pleasure, Tobaye.

[@wayneedmondson1065]

Hi Alan. Awesome example! If the user has Microsoft 365, they can take advantage of the combination of XLOOKUP and FILTER to solve it this way: =XLOOKUP(A2,FILTER(Rates[Date],Rates[Product]=B2),FILTER(Rates[Rate],Rates[Product]=B2),,-1). FILTER essentially creates two virtual tables (lookup_array and search_array) inside XLOOKUP that are isolated to the Product and then can be correctly searched and extracted using the -1 match_mode. Love these problems that can be solved using various methods.. makes you stop and think. Thanks for sharing :)) Thumbs up!!

[@Computergaga]

Thanks, Wayne.

[@Yantraman]

top answer Wayne, I prefer this. thank you

[@wayneedmondson1065]

@@Yantraman Awesome! Thanks :))

[@wasabijim]

This is amazing! I was using the formula but getting the wrong result until I add the other criteria in "Improving the formula" section and it is working perfectly. I have been looking for something like this forever. Your video is very easy to follow. I looked at other videos and they are no where near as easy to follow as you are. Thank you so much!

[@Computergaga]

Glad it helped! Thank you, Jim.

[@maheshhawaldar6673]

Thanks, this helped me lot in my work

[@Computergaga]

Glad it helped! Thank you for the comment.

[@barttitulaerexcelbart9400]

Great video Alan! If I can't remember this formula, I will remember to go to your channel...😉

[@Computergaga]

Thanks, Bart 👍

[@yohiselful]

omg!, this was a headache for even search, thank you very much sr.

[@Computergaga]

You're welcome, Alca.

[@zaheralashker194]

You are genius 🙂

[@Computergaga]

😊

[@dispatchhacks841]

Thank you so much Alan, I didn't understand the formula but this is exactly what I needed in my sheet. After matching the ranges with my data I could get what I needed :) Thank you once again. Subscribed

[@Computergaga]

You are very welcome

[@celinetonio6620]

You just save my life! 😅

[@Computergaga]

Thanks you, Celine.

[@ashwinidevadiga3677]

Without maxifs how to do it?

[@piks974]

This maxifs function doesn't find the exact date on large data. I have a 2 lakhs row number data. Please guide how to resolve on this case.

[@Computergaga]

I'm not familiar with a specific reason why MAXIFS cannot handle data in a large dataset. Too much data is not ideal for an Excel sheet, just generally. Using Power Query could be an alternative, but I do not have a video on this.

[@AliKhan-nt3cm]

Can you please help me on how to do exactly same thing in power bi dax

[@Computergaga]

I don't have a video on that Ali

[@biswadeepdeb4626]

I am following the same formula but I get value error #value! not sure how to fix this.

[@biswadeepdeb4626]

Just got tip from one of the video on fixing value error, all I had to do is press ctlr Shft and Ent, rather then just Ent after typing in the formula.

[@Computergaga]

Nice work| That is an array formula. In Excel 365 and Excel Online, you no longer need to press Ctrl + Shift + Enter, so good news moving forward 🙂👍

[@hariharagupta5638]

Hello sir, this is what I expected for very long time, but unfortunately excel 2016 is not supporting MAXIFS function, can you help with alternate way to support 2016 version to give solution please

[@Computergaga]

This is an alternative formula for the last example in the video. It uses an array formula, so you need to press Ctrl + Shift + Enter instead of just enter.
=INDEX(Rates[Rate],
MATCH(
MAX(IF((Rates[Date]

[@hariharagupta5638]

@@Computergaga thank you very much sir, let me try and update you

[@hariharagupta5638]

Thank you very much sir, i have use the formula and it works as expected, thanks again for your kind reply

[@Computergaga]

@@hariharagupta5638 No worries

[@amandakinmartin1517]

@@Computergaga OMG THANK YOU for sharing this!

[@05meastro]

Hi

[@Computergaga]

Hello

[@emsjabarullah2373]

Super business video OK TH-cam

[@Computergaga]

Thank you 👍

[@excel_along_the_way]

Thanks Alan, really appreciate that last part. Opens a whole new way of looking up things.

[@Computergaga]

Very welcome. Thank you, Lester 👍