Match cells

J

Jason K

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
 
J

Jacob Skaria

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
 
Top