Quote Originally Posted by snb View Post
Do you want to compare only A1 to B1 or A1 to every string in column B ?

I would split the values in column A to colum A:E (texttocolumns)

Then it's easy to compare the values in A1:E1 to the string in column F and put the result of the comparison in column G

See the attachment.

I would like to compare A1 to every string in column B.