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