index small - filter data

hello all

In my sheet "P1" i list all my accounts that will be serviced i.e. cell K13

When i select the service date, the service week automatically get populated (range L13:O13).

Now, start row 69 below, i show the accounts filter by their "service week" from range L13:O13 etc.

The struggle is, my formula (below), is based on data on column L70 down. This formula only filters the account once.

{=IF(ROWS($70:70)>COUNTIF((INDEX(_Data,0,L$68)),$B$70),"",INDEX(Data!$M:$M,SMALL(INDEX(ROW((INDEX(_Data,0,L$68)))+((INDEX(_Data,0,L$68))<>$B$70)*10^10,0),ROWS($70:70))))}

In cell E70, i have the following formula - this formula is dependent on cell L70
{=IF($L70="","",INDEX(_Data,SMALL(IF((INDEX(_Data,0,11))='P1'!$L70,ROW((INDEX(_Data,0,11)))-ROW(Data!$M$5)+1),COUNTIF($L70:$L$70,$L70)),'P1'!E$68))}


My issues comes into play, is that...if cell M78 has a service week, it gets listed, however, in cell E78 the name does not appear and I do not know how to make it show up. I tried if(or(etc but its showing a #value error.

if someone can pls help!

thx u so much!

any thoughts on this guys?

can anyone pls help with this?

any suggestions or how to modify a new formula?