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

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

Thanks for your reponse. but the formula not perfectly work at my end, let me
explain the situation again.

I have Data in two sheets with simillar 'Heads' as follows.

A1 B1 C1

Part Number | Description | Running Nmbers |

the part numbers may be same at various random locations in both sheets, I
want to to compare those sheets with Part Number, where Part Number match
pick the value from Running Number and show the difference in a Cell.

Note: Remeber Part Number may found at random locations (example: in Cell A2
of Sheet 1 part number is '2255' same part number may be found in Cell A15 of
Sheet 2)


Roger Govier wrote:
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

I have two sheets with data in follwoing fields (Heads);

[quoted text clipped - 6 lines]

Thanks

--
Message posted via http://www.officekb.com

Hi

It should work for the description you supply.
If you would like, you can email me a copy of your workbook and I will try
and see what is happening.
To mail direct send to
roger at technology4u dot co dot uk
Change the at and dots to make a valid email address

--
Regards
Roger Govier

"adeel via OfficeKB.com" <u32736@uwe wrote in message
news:8df6e88e84bf2@uwe...
Thanks for your reponse. but the formula not perfectly work at my end, let
me
explain the situation again.

I have Data in two sheets with simillar 'Heads' as follows.

A1 B1 C1

Part Number | Description | Running Nmbers |

the part numbers may be same at various random locations in both sheets, I
want to to compare those sheets with Part Number, where Part Number match
pick the value from Running Number and show the difference in a Cell.

Note: Remeber Part Number may found at random locations (example: in Cell
A2
of Sheet 1 part number is '2255' same part number may be found in Cell A15
of
Sheet 2)


Roger Govier wrote:
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

I have two sheets with data in follwoing fields (Heads);

[quoted text clipped - 6 lines]

Thanks

--
Message posted via http://www.officekb.com