Suppose I have two columns of data. One is a list of names and the other is a list of peoples' names mixed with other stuff.
For instance, one list has "Bob" while the other might have "blank blank Bob blank blank" amongst other cells. Next row would be "Alice" and in the other "Alice blank blank". (assume they aren't sorted in any way"
What would be a formula to check if a cell in the first column is present (a substring) of any cell in the second column?