I am trying to look for a set of characters in a cell. If the characters are found, enter "CB" in the cell and return a 0 (zero) if the characters are not found.



In a separate column, I entered the formula:

=IF(FIND("CACIWC",G4,1)>0,"CB",0)

With the above formula, if the characters are found it works... if they're not found in end up with #VALUE!

What am I doing wrong?

Hi

Try the following:

=IF(ISNUMBER(SEARCH("CACIWC",G4)),"CB",0)

Kevin

Thank you, Kevin... That did the trick.