Bonjour à tous,
Est-il possible de simplifier la formule suivante ?
=SI(ESTNA(SI(ESTNA(SI(ESTNA(INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0))); INDEX('2018'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2018'!$F$2:$F$257;0));INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0)))); INDEX('2017'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2017'!$F$2:$F$257;0)); SI(ESTNA(INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0))); INDEX('2018'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2018'!$F$2:$F$257;0));INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0)))));"-";(SI(ESTNA(SI(ESTNA(INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0))); INDEX('2018'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2018'!$F$2:$F$257;0));INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0)))); INDEX('2017'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2017'!$F$2:$F$257;0)); SI(ESTNA(INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0))); INDEX('2018'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2018'!$F$2:$F$257;0));INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0))))))
Merci d'avance,
Bien cordialement,
WIsh
Est-il possible de simplifier la formule suivante ?
=SI(ESTNA(SI(ESTNA(SI(ESTNA(INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0))); INDEX('2018'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2018'!$F$2:$F$257;0));INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0)))); INDEX('2017'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2017'!$F$2:$F$257;0)); SI(ESTNA(INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0))); INDEX('2018'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2018'!$F$2:$F$257;0));INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0)))));"-";(SI(ESTNA(SI(ESTNA(INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0))); INDEX('2018'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2018'!$F$2:$F$257;0));INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0)))); INDEX('2017'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2017'!$F$2:$F$257;0)); SI(ESTNA(INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0))); INDEX('2018'!$A$2:$A$260; EQUIV('FACTURE ECHUE'!$C11; '2018'!$F$2:$F$257;0));INDEX(ME2N!$A$2:$A$848; EQUIV('FACTURE ECHUE'!$C11; ME2N!$F$2:$F$848; 0))))))
Merci d'avance,
Bien cordialement,
WIsh
Dernière édition: