to check if the values in two sheets are equal

[SKP]

to check if the values in two sheets are equal

 

[Mike H]

A couple of ways:

1. =A1=Sheet2!A1
2. =IF(A1=Sheet2!A1,"The same","Different")

Mike