I need to be able to do this: Take the value in C2 and tell me if that value is anywhere in cell E2. If it is in E2, perform a FIND with C2 value in only the E2 cell, and REPLACE with "" (blank). This is what I have so far. =IF(SEARCH(C57,E57,1) > 0,"Yes","no")
Can anyone help me out with this?
Bookmarks