Help with matching skus and subtracting corresponding values

[Spartan5305]

Hi all, im looking for an equation that would allow me to match the values of the skus and subtract their corresponding values so for examples 1220001 is 28-16 which is 12.

These Skus go on for 10k lines so id love an equation that could match and subtract their values im assuming a type of index-match formula?

Any help would be greatly appreciated

Sku's Value1 Sku Values

1223000 34 1220005 55
1224000 28 1220001 16
1221000 16 1220003 12
1220000 12 1220002 11
1220001 28 1220000 9
1220002 34 1224000 12
1220003 22 1223000 6
1220004 18 1220004 11
1220005 24 1221000 20

[Gregb11]

In absence of any file (please read the yellow banner at the top of the page), assume SKUs start in A3 and your formula goes in E3:


=B3-INDEX($D$3:$D$11,MATCH(A3,$C$3:$C$11,0))