How to lookup a value if the date fall between two dates | Excel Tutorial

In this tutorial video, I am going to demonstrate how to use Match/Index functions to perform a lookup based on a date value to look up a date range (between two dates) and return the corresponding column.

► Buy Me a Coffee? Your support is much appreciated!
------------------------------------------------------------------------------------------
☕ Paypal: paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: join.robinhood.com/jiej6

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter: patreon.com/JieJenn
🛒 By shopping on Amazon → amzn.to/2JkGeMD
🗓 Get updated on new Python videos → facebook.com/MadeInPython/
📘 More tutorial videos on my website → LearnDataAnalysis.org
📺 Also check out my 2nd channel Excel channel focus on sharing Excel tips: bit.ly/3B1DjSA
✉ Business Inquiring: [email protected]

#Excel #ExcelLookup #ExcelTip