how to compare the old code and new code?

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
 
L

Luke M

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

Can't send emails on new PC 1
Consolidation Table from Different Excel Tabs with Different Format 1
Please help me choose a product for the task 2
Student & Home? 1
Can't close old pst file 2
Synchronization problems while moving folders to new email 1
VBA Macro to create 2003 style menus in 2007 and above 1
New computer, how do i move outlook 365 ENTIRELY? 0

Top