In Sheet1 colA you have the plan codes list1

In B1 enter the below formula....(copy the formula down as required)
=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"No match","Match")

which will look at Sheet2 Column A to find a match..

If this post helps click Yes
---------------
Jacob Skaria


"Jason K" wrote:

I would like to find out if cells in a column on one worksheet match any
cells in a range on another worksheet.

I have a list of plan codes that locate in a report.

any help would be greatly appreciated.

thank you