Forum Discussion

Bridget_T's avatar
Bridget_T
Brass Contributor
Sep 24, 2019
Solved

Refining an If statement

Table 1.col A has a list of comments. Col B I currently have an if statement to pick out recurring words to classify the comment. I want to refine this to make it more manageable. Any suggestions. =...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Sep 24, 2019

    Bridget_T 

    Another variant

    =LOOKUP(2,1/ISNUMBER(SEARCH($R$1:$R$4,B2)),$S$1:$S$4)
Bridget_T's avatar
Bridget_T
Brass Contributor
Sep 25, 2019
This was the formula I was working towards - I am still getting #value on the search. However @sergi Baklan suggestion worked - but thanks

Resources