Matching contents

[gary]

Col A has 200 cells (i.e., A1.A200)
Col B has 1500 cells (i.e., B1.B1500)

How can I find the cells in Col A whose contents match the contents in
the cells in Col B?

 

[T. Valko]

Insert a new column A.

Then enter this formula in A1 and copy down to A200:

=IF(ISNUMBER(MATCH(B1,C$1:C$1500,0)),"X","")

Matches will be marked with a "X".