Hello Asother:

I’m only guessing when you say, “formula to subtract the corresponding value that is in column 2 on both sheets”; I hope I’m helping.

Paste this formula in cell Sheet1!C2 and copy down to row 20.

=IF(COUNTIF(Sheet2!A$2:A$20,A2)>0,B2,"")

Paste this formula in cell Sheet2!C2 and copy down to row 20.

=IF(COUNTIF(Sheet1!A$2:A$20,A2)>0,B2,"")

Assuming a total is required for column B, paste this formula in cell B21 on both sheets.

=SUM(B2:B20)-SUM(C2:C20)

Hide column C in both sheets.


Matt