This video demonstrates how to specify multiple partial text string match criteria in a logical test. For example does text contain X and Y. The solution uses the following functions IF, AND, ISNUMBER and SEARCH.
------------------------