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

Using search when it returns #VALUE!
 

=IF(ISERROR(YourSearchFormula),OneFormula, AnotherFormula)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"IanMcGreene" wrote in message
...
|
| 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
|