SOLVED
Home

Identify a given string

leofeltrin
New Contributor

Hi,

I have a list of options:

Análisis, Estimación, Planificación
Construcción
Pruebas de Conectividad
Revisión de Código y Corrección de Incidencias
Documentación de Transporte

 

And I need to identify which one is comming on each row of the worksheet.

 

Additionaly, as these strings may not always be the same, I'm searching for specific key words from each, by using the SEARCH formula, as follows, and once I identify it, I assign a "task type".

 

All these, resulted on the following formula, which is not working properly... it only works with the first FALSE option, but not with the rest.

 

=IF(A2="Requerimiento";C$2;IF(SEARCH("lisis";B2)<>"#VALUE!";C$3;IF(SEARCH("Construcc";B2)<>"#VALUE!";C$4;IF(SEARCH("Prueba";B2)<>"#VALUE!";C$5;IF(SEARCH("Revisi";B2)<>"#VALUE!";C$6;IF(SEARCH("Document";B2)<>"#VALUE!";C$7;))))))

 

Task TypeTasksTask CodeFormula
RequerimientoRequerimientoReqReq
TareaAnálisis, Estimación, PlanificaciónTask_AnalisisTask_Analisis
TareaConstrucciónTask_Construc#VALUE!
TareaPruebas de ConectividadTask_Prueba#VALUE!
TareaRevisión de Código y Corrección de IncidenciasTask_Revision#VALUE!
TareaDocumentación de TransporteTask_Transp#VALUE!

 

Any suggestions?

Thanks

3 Replies
Solution

@leofeltrin ,

 

Instead of

SEARCH("lisis";B2)<>"#VALUE!"

use

ISNUMBER(SEARCH("lisis";B2))

to check if the word is found or not. And be careful with absolute/relative references (perhaps it shall be $A$2 instead of A2 at the beginning, etc). I didn't check entire logic.

@Sergei BaklanIt worked OK!! Thank you!

@leofeltrin , glad to help

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies