Hello I am new to this forum and mostly self taught on excel. I am trying to learn different functions to help speed up my workflow and have discovered the =IF(ISNUMBER(SEARCH function. However when I try it out, it keeps saying false. Even if I just break it down to search it is still returning false and a bit confused by this.
I started with =IF(ISNUMBER(SEARCH("EOC",$G2)),"Yes","No") to test it out to make sure it works but returns false. G2 cell contains "CDC, EOC C/W"
When I reduced it down to =SEARCH(K4,G2) K4 having "EOC" in it, it still returned false.
If it matters, using excel 2013.
Bookmarks