Forum Discussion
Bill_Ruggirello
Sep 26, 2022Copper Contributor
eliminate #VALUE!
I am using Find("XYZ",C1). It works fine if XYZ is in the cell. If it is not I get #VALUE! How can I make it blank if XYZ is not in the cell?
JoeUser2004
Sep 26, 2022Bronze Contributor