How can I return a value by matching date between date range in excel?

How to look up date by date compared to dates in ranges from the start date to the end date?
criteria are countries and delivery date

enter image description here

I try to get the amount from COL_5 of the table service fee to match with country and delivery date

>Solution :

I assume that the first is column "A",

the formula is an array formula, please use the hold shift before entering

{=INDEX($I$2:$I$10,MATCH(1,(D2>=$K$2:$K$10)*(D2<=$L$2:$L$10),0))}

enter image description here

Leave a Reply