Forum Discussion
Multiple IF Statement
I'm trying to use multiple IF(SEARCH) functions to find text within a specific column to return other specific text. I have attached a sample. I would like to write an IF statement that searches f...
mathetes Thank you for your response. This ended up not being a great representation - the key text identifier is not always the first word. I tried using IFS, and still got errors. I'm not great at nesting but that may be my only option.
So create a more representative sample for us to work with.