=SI(ESTNUM(CHERCHE("BX";A94));"BOX";"")&SI(ESTNUM(CHERCHE("CP";A94));"CAP";"")&SI(ESTNUM(CHERCHE("BTL";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BT";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BS";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BSP";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BSF";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BSP";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BTL";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BS1";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BS2";A94));"BOTTLE";"")
=SI(ESTNUM(CHERCHE("BX";A94));"BOX";"")&SI(ESTNUM(CHERCHE("CP";A94));"CAP";"")&SI(ESTNUM(CHERCHE("BT";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BS";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BSP";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BSF";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BSP";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE(OU("BTL";"BT");A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BS1";A94));"BOTTLE";"")&SI(ESTNUM(CHERCHE("BS2";A94));"BOTTLE";"")
=SI(ESTNUM(CHERCHE("BX";A94));"BOX";"")&SI(ESTNUM(CHERCHE("CP";A94));"CAP";"")&SI(ESTNUM(CHERCHE(OU("BTL";"BT";"BS1";"BS2";"BSF";"BSP";"BS");A94));"BOTTLE";"")
=SI(ESTNUM(CHERCHE("BX";A94));"BOX";SI(ESTNUM(CHERCHE("CP";A94));"CAP";SI(ESTNUM(CHERCHE("B";A94));"BOTTLE";"")))
=SI(ESTNUM(CHERCHE("BX";A94));"BOX";SI(ESTNUM(CHERCHE("CP";A94));"CAP";"BOTTLE"))
=SI(SOMMEPROD((ESTNUM(CHERCHE({"BX";"FC";"FD"};$A2)))*1);"BOX";SI(SOMMEPROD((
ESTNUM(CHERCHE("CP";$A2)))*1);"CAP";SI(SOMMEPROD((ESTNUM(CHERCHE({"BS";"BT"};
$A2)))*1);"BOTTLE";"")))
=SI(SOMMEPROD((ESTNUM(CHERCHE(tablo;$A2)))*(tablo<>""))=0;"";INDEX(ligne_1_tablo;
SOMMEPROD((ESTNUM(CHERCHE(tablo;$A2)))*(tablo<>"")*TRANSPOSE(LIGNE(INDIRECT(
"1:"&NBVAL(ligne_1_tablo)))))))
=SI(SOMMEPROD((ESTNUM(CHERCHE(tablo;$A2)))*(tablo<>""))=0;"";INDEX(
ligne_1_tablo;SOMMEPROD((ESTNUM(CHERCHE(tablo;$A2)))*(tablo<>"")*
COLONNE($A$1:$C$1))))
(ESTNUM(CHERCHE(tablo;$A2)))*(tablo<>"")*COLONNE($A$1:$C$1)