Find status using Excel search function

[Dyzone]

Hi!
I made this quite long formula and it works. Maybe there is a short formula/function that will give me the same result?
Thanks for the help.

Please Login or Register  to view this content.

[NBVC]

Are you using ISNUMBER(SEARCH()) because the search string are substrings of the contents of J3784? If so, then you probably can't get much shorter, except for maybe combining the first to searches with same result:

Please Login or Register  to view this content.

If the strings are the exact contents of J3784, the you just need to check equality:

Please Login or Register  to view this content.

[Dyzone]

Thanks, great! NVBC as always.
Both works for me.The second option is enough, since the strings are exact contents of each cell.

No, I used ISNUMBER(SEARCH()) basically to check if it is text or number(correct me if i'm wrong),
and thought it was a good approach to get a good result.

[NBVC]

ISNUMBER(SEARCH()) doesn't check if it is text or number in the cell, it checks first if the value is found in the cell, if it is SEARCH() returns a position number within the cell that the string is found in.. if not it returns a #VALUE! error... the ISNUMBER just checks if the SEARCH() returned a position number, indicating that somewhere in the string the match was found. ... in your case that position is always 1 if found, or #VALUE error if not. Since you have an exact match to find, then simply equality check is all you need.