Search function
Posted by Brian M. on December 19, 2001 1:24 AM
How can I use the search function so that if no match is found it doesn't return a #VALUE! message
Posted by Ian Mac on December 19, 2001 2:21 AM
=IF(ISERR(SEARCH(yourstuff)),"",SEARCH(yourstufagain) (NT)
Posted by Aladin Akyurek on December 19, 2001 2:30 AM
=IF(ISNUMBER(SEARCH(A1,B1)),SEARCH(A1,B1),"")
where A1 houses the search string and B1 the tarhet string.
Aladin
Posted by Mark W. on December 20, 2001 6:33 AM
=MOD(SEARCH(A1,B1&A1),LEN(B1)+1) (nt)
