Forum Discussion
Excel Filtering and Categorization Question?
Hey there,
I'm trying to set up a filtering system and categorization for comments using specific keywords. I have a question: is it possible to have different matching keywords to identify certain text in the comments and then categorize them accordingly? If so, any tips on how I can go about it would be awesome.
Thanks in advance for your help!
I've made an example which could be similar to what you are looking for. There is a reference table with currently two keywords which return the same category. If none of the keywords is found in the comment an empty cell is returned.
Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=IFERROR(INDEX($G$3:$G$7,MATCH(1,ISNUMBER(SEARCH($E$3:$E$7,A2))+ISNUMBER(SEARCH($F$3:$F$7,A2)),0)),"")- Thank you very much! I will get this method implemented and go from there.
Best regards,
