Excel 2007 : Muliple Comparision

Sheet1
Column A Column C Column D
Chq. # Rupees Rupees
125 35,000 0
126 37,000 0


Sheet2
Column A Column C Column D
Chq. # Rupees Rupees
125 0 35,000
127 0 37,000

Please make two comparision
1- Chqeque number should be same (Sheet 1 Cheque number 125 with value Rs.35,000)
2-With same cheque number Rupees also should be same
Both should be telly same cheque numer with rupees of cheque number.
Amount of same in different column and different rows
Data is taken from ledger posting and bank statements.

Remarks
Result in tick marks in Column B