Forum Discussion
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. =...
If you create a Lookup Table like this... (in this case the Lookup Table is created in the range R1:S4)
Then you can simply use this formula...
=INDEX($S$1:$S$4,MATCH(TRUE,ISNUMBER(SEARCH($R$1:$R$4,B2)),0))
Just change the ranges referred in the above formula based on the range of your Lookup Table and the formula will work correctly.
This was the formula I was working towards - I am still getting #value on the search. However @sergi Baklan suggestion worked - but thanks
No problem! 🙂