=SI(SOMMEPROD(($A$2:$A$8=$F2)*($C$2:$C$8))>0;"OK";"")
=SIERREUR(INDEX($B$2:$B$8;PETITE.VALEUR(SI(($A$2:$A$8=$F2)*($C$2:$C$8<>"");LIGNE(INDIRECT("1:"&LIGNES($A$2:$A$8))));COLONNES($G:G)));"")
=SIERREUR(INDEX($B$2:$B$8;PETITE.VALEUR(SI(($A$2:$A$8=$F2)*($B$2:$B$8=G$1)*($C$2:$C$8<>"");LIGNE(INDIRECT("1:"&LIGNES($A$2:$A$8))));1));"")
=SI(NB.SI.ENS($A$2:$A$8;$F2;$B$2:$B$8;G$1;$C$2:$C$8;"<>");G$1;"")
=SOMMEPROD(($A$2:$A$8=$F2)*($B$2:$B$8=$G2)*($C$2:$C$8=H$1);$D$2:$D$8)