=SIERREUR(INDEX(DECALER(ABSENCES!$F$1;1;EQUIV(A$14;ABSENCES!$G$1:$O$1;0);20);EQUIV(1;($B$9=ABSENCES!$E$2:$E$21)*($B$10=ABSENCES!$F$2:$F$21)*($B$11=ABSENCES!$C$2:$C$21)*($B$12=ABSENCES!$B$2:$B$21)*($B$13=ABSENCES!$A$2:$A$21);0));0)
MerciBonjour à tous,
Formule matricielle à essayer:
VB:=SIERREUR(INDEX(DECALER(ABSENCES!$F$1;1;EQUIV(A$14;ABSENCES!$G$1:$O$1;0);20);EQUIV(1;($B$9=ABSENCES!$E$2:$E$21)*($B$10=ABSENCES!$F$2:$F$21)*($B$11=ABSENCES!$C$2:$C$21)*($B$12=ABSENCES!$B$2:$B$21)*($B$13=ABSENCES!$A$2:$A$21);0));0)
JHA