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!
------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#Excel #ExcelLookup #ExcelTip

[ErcanYagci]

Thanks. This was the one and only answer to my question on the web.

[TriciaBinGSO]

Thank you so much! This helps me determine which quarter a date falls into. SO helpful.

[conradriddle]

and all this time I was stacking if formulas inside each other, one for every row in the reference. THIS IS SO MUCH BETTER!! THANK YOU!

[MisterViewerWillSee]

This is excellent! Thank you! I've looked at videos for two hours trying to figure this out. You explained it quickly and easily. I didn't understand why you put curly brackets on the formula at the end because it didn't work, but when I took off the curly brackets then it worked. Is there a purpose for the curly brackets?

[farzanarahman]

Thank you sooo much, this formula was exactly what I was looking for!!! <3

[abhaysinghpro]

Not just saved my day, you saved my weeks. Much appreciated.

[paulasmithyman]

Hi Jie,
Thank-you
This was very helpful!

[knass]

Thank you! I hadn't needed to do this in a while and really appreciate this helpful explanation! I needed to add another column to the array, but once I had the dates figured out, the additional criteria was simple.

[linhtut]

I don't understand lookup value 1 in match function. Could you please help me explain?

[myytexp]

This is exactly what I wanted and you have helped me BIG TIME!! BIG THANKS :)

[topiasr]

Dude. I've literally been trying to figure out this problem all day! THANK YOU!!

[mdaraque]

THANK YOU!! You just saved me so much time on my report!

[sharathrao]

Thanks a lot. I never knew this formula. This is actually very helpful in my reporting at work. Keep posting such useful videos.

[viniciusmartins]

Thank you for the amazing video! But I have one question! What if i have to include a criteria in this formula? Like: i need to search an ID in the range between two dates? What i have to do?

[kimberlychenze]

This formula is exactly what I was hoping to find!, You are the best!

[weiluk]

Thanks for your help. I want to do a calculation once I find a Match. do you have any video about that? So, once I locate the date fall into the date range, I would like to know the number of days between the 2 days

[ricardobrizuela]

I miss why it is “1” in the formula..? Would you please explain?

[shyjumathew]

I have a calendar and need to find one/range of date/s, please advise, thanks

[sarahw]

Thank you for your clear and thorough demonstration - this is exactly what I needed to do with my data!

[neelimayenuga]

Can't thank you enough, this is exactly what I was looking for, thank you!