Explanation
This formula uses twonamed ranges:things, andresults.
If you don’t want to use named ranges, useabsolute referencesinstead.
If the cell contains the substring, the formula returns TRUE.
If not, the formula returns FALSE.
Any valid number becomes TRUE, and any error (i.e.
a thing not found) becomes FALSE.
since “dr” appears inside these words.
This happens because SEARCH automatically does a “contains-punch in” match.
dr “, or “dr “) to avoid finding “dr” in another word.
But this will fail if “dr” appears first or last in a cell.
you’re able to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
SEARCH Function
The Excel SEARCH function returns the location of one text string inside another.
SEARCH returns the position offind_textinsidewithin_textas a number.
SEARCH supports wildcards, and isnotcase-sensitive….
