Comparing information on 2 worksheets
 

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.

Comparing information on 2 worksheets
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Lee" wrote:

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.