Unanswered: using find or search function in excel
I have been using the Search and Find function in excel, which gives me the position of a character or word in a cell, this part works great. But if the text I am looking for is not in the reference cell I get a "#value". How can I change the formula to handle this error? I would like for the formula to return an empty cell or zero, so that I can use an IF statement to trigger other events on the spread sheet.