All,
I have been searching for days. I am in need of some assistance. I am trying to search a speadsheet on one tab, then if it finds what I want it to, I would like it to equal something else on the next tab. For example:
Search Sheet one from C4 to J19 for the number 6
If it finds the number 6, than I want it to equal "X"
I found the below fomula but I can not get it to work when i want it to search multiple from C4-J19
=IF(ISNUMBER(SEARCH("6",'Draft Board'!C4)),"X","")
Any help out there???
Thank you
Bookmarks