Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search for date in long string of text | Excel Discussion (Misc queries) | |||
Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
Search Entire Workbook | Excel Discussion (Misc queries) | |||
Search within workbook | New Users to Excel | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) |