Formula error

[travelinman]

The following formula returns a #Value! error message if the text "Update" is
not found. I tried using ISERROR and could not get it to work. I would like
to display a blank cell if th text is not found. Any ideas?

=IF(FIND("Update",C2)>0,"x",)

 

[Mike H]

Hi,

Try this. Unless you have a reason for doing so use search instead of find
which is case sensitive

=IF(ISNUMBER(SEARCH("Update",C2)),"x","")

Mike

 

[travelinman]

Thanks for being so quick Mike. Appreciate the effort. It worked fine and I
learned about the case sensitive feature.