how to compare the old code and new code?

  • Thread starter Thread starter Pradeep_ji78
  • Start date Start date
P

Pradeep_ji78

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
 
Back
Top