Hello
Use the formula = SE (SEARCH ("METHODS"; J28); "METHODS"; "OTHER") to locate certain texts in a column, but I could not put more than one conditional to have all the answers in a single column, I had to make a column for every text I'm looking for. Above in the conditional formula should return "Other", but it is another error that happens, because comes the following answer #VALOR !. In the same column I have the following particularity that prevents me from finding what will be defined as "EXAME", because there is the text "REC." for when I also look for "DIAGNOSTIC" and "GRAPHIC METHODS"; Below the form that I managed to structure so far, but I could not evolve;
REC. BELVEDERE DIAGNOSTIC CENTER > > = SE (SEARCH ("DIAGNOSTIC", J5087), "IMAGE", "OTHER")
REC. BARREIRO - GRAPHIC METHODS > > = SE (SEARCH ("METHODS"; J5090); "METHODS"; "OTHER")
REC. BELVEDERE > > = SE (SEARCH ("REC", J5095), "EXAM", "OTHER")
SAVASSI VACCINE > > = SE (SEARCH ("VACCINE", J462), "VACCINE", "OTHER")
I hope someone can help me! Thanks in advance !!