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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking new phone to computer. 7
IPhone sound quality gets worse each generation 5
Alt codes 4
VLOOKUP gives duplicate results for "empty" searches 4
Access Compare records in same access table 0
comare and copy 3
Import File Information 0
Conditional formating based on multiple comparisons 1

Back
Top