Match and Extract -LAMBDA,MAP,FILTER

Originally Posted by windknife

Amended formulas.

Y10

=LET(
     a,CHOOSECOLS(FILTER('P1'!$B$5:$BJ$2100,'P1'!$B$5:$B$2100<>""),1,59,60,61),
     y,MAP(F10:F100,LAMBDA(x,IF(x="","",IFERROR(INDEX(TOROW(IF(ISNUMBER(SEARCH(INDEX(a,,1)&" ",SUBSTITUTE(x,"/"," ")&" ")),a,NA()),3),3),"")))),
     z,MAP(F10:F100,LAMBDA(x,IF(x="","",IFERROR(INDEX(TOROW(IF(ISNUMBER(SEARCH(INDEX(a,,1)&" ",SUBSTITUTE(x,"/"," ")&" ")),a,NA()),3),4),"")))),
     r,HSTACK(y,z),
     IF(r=0,"",r)
)

AC10

=LET(
     a,CHOOSECOLS(FILTER('P1'!$B$7:$BJ$2100,'P1'!$B$7:$B$2100<>""),1,59,60,61),
     b,MAP(F10:F100,LAMBDA(x,IF(x="","",IFERROR(INDEX(TOROW(IF(ISNUMBER(SEARCH(INDEX(a,,1)&" ",SUBSTITUTE(x,"/"," ")&" ")),a,NA()),3),2),"")))),
     IF(b=0,"",b)
)

Hi,windknife,

I think you have done it finally.Lateron on night I will check the accuracy of data but seems to have been done.

Thanx again for your kind effort.