Match and Extract -LAMBDA,MAP,FILTER

How about these?

Y10

=DROP(REDUCE(0,F10:F101,LAMBDA(x,y,VSTACK(x,LET(
   a,TOROW(IF(ISNUMBER(SEARCH('P3'!B7:B15,y)),'P3'!BH7:BJ15,NA()),3),
  IF(y="",""=DROP(REDUCE(0,F10:F101,LAMBDA(x,y,VSTACK(x,LET(
   a,TOROW(IF(ISNUMBER(SEARCH('P3'!B7:B15,y)),'P3'!BH7:BJ15,NA()),3),
  IF(y="","",INDEX(a,3)))))),1)
,INDEX(a,2)))))),1)

AC10

=DROP(REDUCE(0,F10:F101,LAMBDA(x,y,VSTACK(x,LET(
   a,TOROW(IF(ISNUMBER(SEARCH('P3'!B7:B15,y)),'P3'!BH7:BJ15,NA()),3),
  IF(y="","",INDEX(a,1)))))),1)

Z10