For 2021 version.
Y10
AC10![]()
=LET( a,'P1'!$B$5:$BJ$2100, b,MIN(IF(ISNUMBER(SEARCH(INDEX(a,,1)&" ",SUBSTITUTE($F10,"/"," ")&" ")),ROW($B$5:$BJ$2100),"")), c,IF($F10="",{"",""},INDEX(a,b-4,{60,61})), IF(c=0,"",c) )
Both copied down.![]()
=LET( a,'P1'!$B$5:$BJ$2100, b,MIN(IF(ISNUMBER(SEARCH(INDEX(a,,1)&" ",SUBSTITUTE($F10,"/"," ")&" ")),ROW($B$5:$BJ$2100),"")), c,IF($F10="","",INDEX(a,b-4,59)), IF(c=0,"",c) )
Bookmarks