By default, when you perform a look up (VLOOKUP or INDEX/MATCH) in Excel, you can only match a value either by exact match or approximate match. If you want to look up a value in a range or between two dates, you can use something called array formula.

In this tutorial video, I am going to demonstrate how to use Match/Index functions to perform an array formula action to lookup a date between two dates and return the correspond column.