Comparing information on 2 worksheets

L

Lee

I am trying to compare certain information on 2 different worksheet to make
sure both are listed. Is there an easy way to do this. Possible turn the
cells a different color if the information is not on one worksheet.
 
L

Luke M

Depending on your layout, you could try
=MATCH(Sheet1!A1,Sheet2!A1:A100,0)

The 0 at end designates and exact match. If the two sheets should be
perfectly identical, just change the array to a single cell refernce. If no
match is found, an error is returned.
 

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

Compare difference between 2 worksheets 2003 1
Comparing data in multiple worksheets 3
Comparing the difference between 2 worksheets 2
Comparing data within worksheets 3
Linking multiple Worksheets 1
WOrksheets 2
Need to merge worksheets - Excel 2003 0
How do I lookup data from multiple worksheets? 2

Top