I am trying to determine if any of the individual strings in an array/table of strings (i.e. Sheet2 A1:A4) is a substring in another cell (Sheet1 A1).
Sheet1 A 1 "Letter to Bob" Sheet2 A 1 Sam 2 Bill 3 Bob 4 Dick
Are any of the strings in Sheet2 A1:A4 inside the Sheet1 A1 string?? (In this example, the answer is Yes… Bob is found in Sheet1 A1)
What would the formula to accomplish this look like??