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

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

CodePudding user response：

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))}