Perform a Lookup Based On a Value Between Two Values

Apr 15, 2019 | Excel, Excel General

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...