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)
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
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

    ThanksSergeiBaklan this worked just as I wanted - Much appreciated.

Resources