Hi Shilabrow

I think it is partially working. I am assuming that the B2 portion of your formula looks at the data in B2 and compare it to the whole column?

Thing is one column is 923 lines of names, and I need to compare a list that is 304 lines

So say A2 onwards is 923 names, B2 onwards is 304 names, I need column C to say are any of the 304 names appearing in the list of 923 names? (not sure if that makes sense, I think the formula so far (unless I am using it incorrectly) is looking at one name at a time.