As explained in part one, the SEARCH function in Excel is very similar to FIND because it also returns the location of a substring in a text string.
The syntax and arguments are akin to those of FIND.
The breakdown of this is:
If the SEARCH function does not find the find_text character(s), a #VALUE! error is returned.
When a value is not found, the result will be an error. This was also the case in the FIND function. The function =SEARCH(“F”;”OPERAHOUSE”) gives an error as result!