Lookup Value Based On Two Criteria

I have two pivot tables (for sales and purchases) with three columns each, ie: company 1, company 2 and amount

I need to reconcile that for the internal purchases and sales the sale value is the same as the purchase.

So in first pivot table (purchases) I have one row with internal transactions where company 1 = AZS, company 2 =YDR, value 100

In second pivot table (sales) I have one row with internal transactions company 1= YDR, company 2 = AZS, value 95

I would like to develop a macro that would check automatically the combinations of companies and find out if there are differences between sales and purchase. So in the example it should show that there is 5 usd more in purchases. Hopefully normally is zero