Match cells

  • Thread starter Thread starter Jason K
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel VBA 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Compare Two Cells 1
Matching records in two lists 2
Macro or Look-up? 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Check multiple cells for a match 5

Back
Top