Hello,
I am trying to build a formula with multiple criteria. I know there are a fews ways of doing this. However, what I am trying to add to that formula is a text search, than a return of a different value. So, basically, I can get me formula to work fine, and it will return the appropriate value...but I do not want that value.... I want to return something different based on a search.
So, if the answer to my multiple index match contains the work "orange"; please return "O", if the answer contains the word "orange" and "banana", please return "BB", if the answer contains the word "dog" please return "P"; if the results is a blank cell, return blank.
Here is my current index match formula without that word search:
{=INDEX('Assessment Extract'!$F$2:$F$3510,MATCH(Sheet2!C$3&Sheet2!$B5,'Assessment Extract'!$C$2:$C$3510&'Assessment Extract'!$E$2:$E$3510,0))}
I am trying to build a formula with multiple criteria. I know there are a fews ways of doing this. However, what I am trying to add to that formula is a text search, than a return of a different value. So, basically, I can get me formula to work fine, and it will return the appropriate value...but I do not want that value.... I want to return something different based on a search.
So, if the answer to my multiple index match contains the work "orange"; please return "O", if the answer contains the word "orange" and "banana", please return "BB", if the answer contains the word "dog" please return "P"; if the results is a blank cell, return blank.
Here is my current index match formula without that word search:
{=INDEX('Assessment Extract'!$F$2:$F$3510,MATCH(Sheet2!C$3&Sheet2!$B5,'Assessment Extract'!$C$2:$C$3510&'Assessment Extract'!$E$2:$E$3510,0))}