This Excel Tutorial explains, How to compare data in two excel sheets with simple formula.
We can compare two data sets in 2 excel sheets using simple if formula.

Formula used in tutorial is : =IF(Sheet1!B2=Sheet2!B2,"True","Sheet1 : "&Sheet1!B2&"Sheet2 : "&Sheet2!B2)