Use multiple "if" conditions to find a text

0

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 !!

    
asked by anonymous 21.04.2018 / 20:02

0 answers