Thanks SirJB7, I read the Sticky posts and was just about to Dropbox my example when Luke M gave me the solution! You guys are awesome, thanks a million!
Hi - I'm new to this forum so first, thanks for being here!
I have a column of data containing various text strings in each cell (colA), I want to evaluate these strings to see if any words from another list specified in another column (ColB) occur anywhere in the value of the first column...