Thread: Using search when it returns #VALUE!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IanMcGreene IanMcGreene is offline
external usenet poster
  
Posts: 1
Default Using search when it returns #VALUE!

I am trying to figure out how I can use the SEARCH function when it does
not find what it is looking for and returns an error.

I want to make an if statement that does one thing when the search
finds a string, and another if it does now. But if it does not find
what it is looking for it just returns #VALUE! and errors out.

Any ideas?


--
IanMcGreene
------------------------------------------------------------------------
IanMcGreene's Profile: http://www.excelforum.com/member.php...o&userid=37247
View this thread: http://www.excelforum.com/showthread...hreadid=571958

Reply With QuoteReply With Quote