Index based on time period and value

[purlo]

This post is related to my previous post here: https://www.excelforum.com/excel-for...ml#post5327870
I'm successfully using this formula:
=IFERROR(LOOKUP(2,1/($K$3:$K$17=B$1)/($I$3:$I$17>=$A2)/($I$3:$I$17<$A2+7),$J$3:$J$17),"")
But now I want to add one more condition - end date. So now I'm searching for the formula that would allow me to return values based on date interval.
As you see in example, I have start and end dates for specific event. My purpose is to return events based on specific date period (in this case is all weeks of the year). In my raw date, event can extend through the multiple weeks, in that case formula should return value twice, even trice.
Example is in attachment.
Thank you very much!

[Bo_Ry]

Please try at B2

=IFERROR(LOOKUP(2,1/($K$3:$K$17=B$1)/($L$3:$L$17<=$A2)/($M$3:$M$17>=$A2),$N$3:$N$17),"")

[purlo]

Thanks! I also find a way just by editing existing formula, to use end date: =IFERROR(LOOKUP(2,1/($K$3:$K$17=B$1)/($I$3:$I$17>=$A2)/($I$3:$I$17<$A2+7),$J$3:$J$17),"")