I have old code and old description in my excel. Now company given me new
code with same description. I want to compare the old code with new code but
description is same. how to compare?

regards,
pradeep.K

Lets say your old data is in A:B and new data is in C:D (with description in
A and C)

In E1:
=VLOOKUP(C1,A:B,2,FALSE)

This will find the old code. If you want to highlight where changes have
occured:
=VLOOKUP(C1,A:B,2,FALSE)=D1



--
Best Regards,

Luke M
"Pradeep_ji78" wrote in message
...
I have old code and old description in my excel. Now company given me new
code with same description. I want to compare the old code with new code
but
description is same. how to compare?

regards,
pradeep.K

Print both sets of code and compare side by side?


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 10:49:03 -0700, Pradeep_ji78
wrote:

I have old code and old description in my excel. Now company given me new
code with same description. I want to compare the old code with new code but
description is same. how to compare?

regards,
pradeep.K