I'm trying to write a formula to determine if text in one cell is contained in another cell. The romula I've built so far is =IF(SEARCH(G2,F2,1)>0,"Pass","Fail"
If the text is found, Pass is returned in the box. If it's not found, #Value is returned. I've had this problem quite frequently in various programming applications where a function returns an error value rather than, say, false, or -1. I also tried using =if(error.type(Search(G2,F2,1))=3,"Fail","Pass". This works if the text is not found, but doesn't work if it is. I need a function that doesn't return error values under normal conditions, or a way of manipulating error producing functions in non-error producing comparisons. Can anyone help
If the text is found, Pass is returned in the box. If it's not found, #Value is returned. I've had this problem quite frequently in various programming applications where a function returns an error value rather than, say, false, or -1. I also tried using =if(error.type(Search(G2,F2,1))=3,"Fail","Pass". This works if the text is not found, but doesn't work if it is. I need a function that doesn't return error values under normal conditions, or a way of manipulating error producing functions in non-error producing comparisons. Can anyone help