to check if the values in two sheets are equal
M Mike H Nov 29, 2007 #2 A couple of ways: 1. =A1=Sheet2!A1 2. =IF(A1=Sheet2!A1,"The same","Different") Mike
