=SOMMEPROD((ESTNUM(CHERCHE(H$3&"*";$B$3:$E$3)))*(ESTNUM(CHERCHE(H$2&"*";$B$2:$E$2)))*(DECALER($L$3;1;EQUIV(H$2&"*"&H$3&"*";$M$2:$O$2&$M$3:$O$3;0);4)=$G4);($B$4:$E$7))
(ESTNUM(CHERCHE(H$3&"*";$B$3:$E$3))){/CODE]
Est numérique la recherche du mot + * en H3
Condition 2 : [CODE](ESTNUM(CHERCHE(H$2&"*";$B$2:$E$2)))
(DECALER($L$3;1;EQUIV(H$2&"*"&H$3&"*";$M$2:$O$2&$M$3:$O$3;0);4)=$G4)