Bonjour Maud
Bienvenue su XLD et bonne anné
En D2: =SI(OU(B2="SKR";B2="JUMBO";B2="REP");"Kilian";"Kelly")
Hello,
J'ai cette formule, ca marche pour certains et d'autres ca marque False ... j'ai tout reverifie et je ne trouve pas pourquoi ... (elle est trop longue ? et il marque les mauvais prenoms pour certains, dois-je mettre $ devant le texte a chercher des formules ?) Merci
=IF(ISNUMBER(SEARCH("PMR",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("LOGOS",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("VIAGGI",RC[-2])),"Noemi",IF(ISNUMBER(SEARCH("Evaneos",RC[-2])),"Maud/Kilian",IF(ISNUMBER(SEARCH("RDB",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("CXKG",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("INSOLITES",RC[-2])),"Maud ",IF(ISNUMBER(SEARCH("ZICASSO",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("MST",RC[-2])),"Noemi",IF(ISNUMBER(SEARCH("TEAM",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("TUI",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("ZEN D’ASIE",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("EHT",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("NF",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("MPI",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("LP",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("LPN",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("SRD",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("COMPAGNIE DES CONTINENTS",RC[-2])),"Maud ",IF(ISNUMBER(SEARCH("MD",RC[-2])),"Noemi",IF(ISNUMBER(SEARCH("PPD",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("I GRANDI VIAGGI",RC[-2])),"Noemi",IF(ISNUMBER(SEARCH("Partir",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("EAST ASIA",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("DESI",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("MIST",RC[-2])),"Noemi",IF(ISNUMBER(SEARCH("TUCANO VIAGGI",RC[-2])),"Noemi",IF(ISNUMBER(SEARCH("CLUB VIAGGI",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("PPR",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("TI",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("DESTINO ASIA",RC[-2])),"Noemi",IF(ISNUMBER(SEARCH("GERN",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("EXOV",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("DIR",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("ALTIPLANO",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("IL GABBIANO LIVINGSTON",RC[-2])),"Noemi",IF(ISNUMBER(SEARCH("CARTHORANGE",RC[-2])),"Noemi",IF(ISNUMBER(SEARCH("ARTHEMA",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("STRAY",RC[-2])),"Noemi",IF(ISNUMBER(SEARCH("ASIE ONLINE",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("ROUTE VOYAGES",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("VISI",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("MSVOYAGES",RC[-2])),"Maud ",IF(ISNUMBER(SEARCH("ON TOUR",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("RDL",RC[-2])),"Maud",IF(ISNUMBER(SEARCH("RDM",RC[-2])),"Maud ",IF(ISNUMBER(SEARCH("SIC",RC[-2])),"Kilian",IF(ISNUMBER(SEARCH("DGV",RC[-2])),IF(ISNUMBER(SEARCH("Elite Travel",RC[-2])),IF(ISNUMBER(SEARCH("FANTASIA",RC[-2])),"Maud/Kilian",IF(ISNUMBER(SEARCH("MDT",RC[-2])),"-",IF(ISNUMBER(SEARCH("VDM",RC[-2])),"-",IF(ISNUMBER(SEARCH("AST",RC[-2])),"-",IF(ISNUMBER(SEARCH("STD",RC[-2])),"-",IF(ISNUMBER(SEARCH("JUMBO",RC[-2])),"-")))))))))))))))))))))))))))))))))))))))))))))))))))))))