Since tables are on the same sheet I can not use Vlookup
so far I used
=IF(ISNA(VLOOKUP($A560,$D$5:$E$455,2,0)),0,(VLOOKUP($A560,$D$5:$E$455,2,0))). but now I need to take only the values that are combine in both and reject that are not. So if the amount in both tables is same for the given ID, or if one has the amount and other does not again for the same ID. I do not want it, I only need in both table have an amount for the same ID and the amounts are different.
I used =SUMIF(G4:G575,"=0",H4:H575) and
=SUMIF(G4:G575,"<>0",H4:H575) to sum of same or no values.
But doing all that I have $60K difference, so I dicided to use Match Index formula.