Thedouble negativewill force the TRUE and FALSE values to 1 and 0 respectively.

Logically, any result greater than zero means that at least one value exists in the range.

So, the final step is to evaluate the SUMPRODUCT result to see if its greater than zero.

Excel formula: Value exists in a range

Any result greater than zero returns TRUE, and any result equal to zero returns FALSE.

If you’re gonna wanna look for substrings, you canuse this formula instead.

SEARCH Function

The Excel SEARCH function returns the location of one text string inside another.

Excel formula: Range contains specific text

SEARCH returns the position offind_textinsidewithin_textas a number.

SEARCH supports wildcards, and isnotcase-sensitive….

Excel formula: Range contains one of many substrings

Excel SUMPRODUCT function

Excel ISNUMBER function

Excel SEARCH function