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.
 
Top