Crear Una formula de SI con varias condiciones

%3CLINGO-SUB%20id%3D%22lingo-sub-1306429%22%20slang%3D%22es-ES%22%3ECreate%20an%20SI%20formula%20with%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1306429%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20am%20looking%20for%20a%20compound%20IF%2FSI%20formula%2C%20where%20if%20inside%20the%20cell%20is%20a%20series%20of%20words%20mixed%20with%20numbers%20I%20write%20a%20code.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20If%20in%20cell%20A1%20is%20the%20letter%20RDM%20type%20J59K%2C%20but%20if%20it%20is%20J0%2C%20type%20HC%2C%20if%20this%20R1%20that%20writes%20BR2%20and%20so%20cosecutively%2C%20you%20would%20be%20looking%20for%208%20different%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22146px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22145px%22%3ERDM92-452140%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22145px%22%3EJ0924-22360%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22145px%22%3EM4924-02240%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22145px%22%3EJ0924-01310%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22145px%22%3EM4924-01240%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22145px%22%3EM4924-03240%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22145px%22%3EH9924-35330%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22145px%22%3EH9924-30460%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22145px%22%3EM7924-32330%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22145px%22%3EBJM92-412820%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1306429%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

estoy buscando una formula IF / SI compuesta, donde si dentro de la celda esta una serie de palabras mezclada con numeros me escriba un codigo.

 

Ejemplo: Si en la celda A1 esta la letra RDM escribir J59K, pero si esta J0, escribir HC, si esta R1 que escriba BR2 y asi cosecutivamente, estaria buscando 8 diferentes 

 

RDM92-452140
J0924-22360
M4924-02240
J0924-01310
M4924-01240
M4924-03240
H9924-35330
H9924-30460
M7924-32330
BJM92-412820
0 Replies