MATCH This function helps to locate the position of a lookup value in a row column or table. Which is fed into the MATCH function as the lookup array with a lookup value of 1. I found a formula on internet that allows me to check if a date-value in a certain cell falls within the date range of a school holiday.
When you use an array in INDEX MATCH or a combination of those two functions it is necessary to press CtrlShiftEnter on the keyboard.
Heres the revised formula with the MATCH function nested inside. Read more on the MATCH function. Any lookup function including a normal MATCH INDEX. The result is 395 the price of the Caffe Mocha size Grande.