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 certa...
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,
