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...
Maybe your example is not really representative of the real data you'll be working with, but IF in fact the color in question is always the first word in the text being searched, the formula below works just fine. See the attached file (i changed the name, but it's your file with my solution)
=LEFT([@[Item Description]],FIND(" ",[@[Item Description]])-1)
Otherwise, using a series of nested IFs can get really complicated. You might try the function IFS instead.
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.