Forum Discussion
IFS(OR(ISNUMER(SEARCH( function
Is there a way to simplify this part of my IFS function: IFS(OR(ISNUMBER(SEARCH("aanvraag opleiding",F619)),ISNUMBER(SEARCH("Aanvraag cursus",F619)),ISNUMBER(SEARCH("Toekenning aanvraag",F619)),I...
Mmmm does the attached do what you need?
It should, check the text for any of the words in the list, return the 'category' from the column next to it.
This doesn't work with how my data is organised. It is like this:
Big category medium category small category
small category
medium category
Big category medium category small category
small category
medium category
Big categorty medium category
medium category