Hi

On Sheet 1, enter in D1 Difference and in D2
=C2-INDEX(Sheet2!C:C,MATCH(A2,Sheet2!A:A,0))
and copy down as required

--
Regards
Roger Govier

"adeel via OfficeKB.com" <u32736@uwe wrote in message
news:8df40cef10613@uwe...
I have two sheets with data in follwoing fields (Heads);

| Part Number | Description | Running Numbers |

Now I want to compare these two sheets with Part Number, if Part Number
match,
pick up the data from Running Numbers of Sheet 1 & Sheet 2 and give the
Difference of these numbers in a Cell.

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200811/1