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?
Bookmarks