subtract values from two sheets

[coxixx]

Hi
i have two sheets

sheet one
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]id[/TD]
[TD]values[/TD]
[/TR]
[TR]
[TD]11200[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]11201[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]11202[/TD]
[TD]300[/TD]
[/TR]
</tbody>[/TABLE]








sheet two

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]id[/TD]
[TD]values[/TD]
[TD]result[/TD]
[/TR]
[TR]
[TD]11200[/TD]
[TD]1000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11202[/TD]
[TD]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11201[/TD]
[TD]4000[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]







i wanna subtract values base on id and insert in result column for example for id 11200 result will be 1000-100 . (data are not sorted)
is it possible?
thank you

 

[JackDanIce]

Try:

=B2-IFERROR(VLOOKUP(A2,Sheet1!$A$1:$C$100,2,0),0)

 

[coxixx]

thank you so much.

 

[JackDanIce]

You're welcome.