Yea, I reread the original question. For some reason I initially thought he wanted to compare the same rows of the columns.

To check anywhere in the column I would use VLOOKUP too. I should have read more carefully.