Google Sheets: Finding a partial match

Right now I have the following in for conditional formatting: =if(I43="Trait Dependency", False, IF(I43="None", False, if(isna(match(I43,B23:B40,0)),True, False)))

When its checking I43's value for a match in B23:B40 is there a way to check it for a partial match?

So lets say I43 = "Thing One or Thing Two" I want the sheet to check if any value in B23:B40 contains "Thing One" or "Thing Two" that way the formatting will return True if "Thing One" or "Thing Two" is present, but return false under other conditions



Read more here: https://stackoverflow.com/questions/68462123/google-sheets-finding-a-partial-match

Content Attribution

This content was originally published by Bailey Singer at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: