=SI(SI(ESTNUM(INDEX($C$3:$C$308;EQUIV(H$2&$G3;$A$3:$A$308&$B$3:$B$308;0)));INDEX($C$3:$C$308;EQUIV(H$2&$G3;$A$3:$A$308&$B$3:$B$308;0));INDEX($E$3:$E$308;EQUIV(H$2&$G3;$A$3:$A$308&$D$3:$D$308;0)))>0;"N";"O")
=SI(OU(SIERREUR(INDEX($C$3:$C$308;EQUIV(H$2&$G3;$A$3:$A$308&$B$3:$B$308;0));INDEX($E$3:$E$308;EQUIV(H$2&$G3;$A$3:$A$308&$D$3:$D$308;0)))=0;SIERREUR(INDEX($E$3:$E$308;EQUIV(H$2&$G3;$A$3:$A$308&$B$3:$B$308;0));INDEX($C$3:$C$308;EQUIV(H$2&$G3;$A$3:$A$308&$D$3:$D$308;0)))=0);"O";"N")