Updated Parts list compare

BasicUserWithExp

New Member
Joined
Feb 15, 2018
Messages
22
I have 2 lists with the same format. The old list was updated and rearranged. the parts column and/or the description columns changed, by a numbered column. I Have to re-label all the parts on a drawing with the correct number, the old might be 36, the new would be the same part/description, but the number is 124. I have to find the current number on the drawing look up the part# on the old list, then find the part# on the other to find the line number to update. I just need a column on the new page that shows the new number.here is the file
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
how about
=INDEX('old MASTER LIST'!D:D,MATCH('new MASTER LIST'!B2&'new MASTER LIST'!C2,'old MASTER LIST'!B:B&'old MASTER LIST'!C:C,0))

assuming the supplier and the desciption remains the same and match on those 2 items

because of the size only show a part of each sheet

on dropbox - but only for a few days

as you can see only a few part numbers are changed - column G - and highlight

i suspect this maybe real data , and is now on the internet - is that the case ?? if so - you may want to

so i deleted xl2bb, as i cannot edit that in post later
and can delete the dropbox file

BUT is this real data and private !!!
 
Last edited:
Upvote 0
The part numbers don't change it is the numbers in the "Find" Column that change.
 
Upvote 0
do you have the same partnumber repeated at all ?
same index match but with the Partnumber - does not look like it from the list

how about
=INDEX('old MASTER LIST'!A:A,MATCH('new MASTER LIST'!D2,'old MASTER LIST'!D:D,0))

but i dont get any that match

did you want the dropbox file deleted ?? - you didnt answer that question
 
Upvote 0
I need the "find" number from the new list that matches the part from the old list in this file. There may be some that can't be matched or are removed.
FYI: all info on this list can be found on the Internet.
 
Upvote 0
try
=INDEX('new MASTER LIST'!A:A,MATCH(C2,'new MASTER LIST'!C:C,0))

Although - the part numbers do not match - i had to recopy - I suspect a hidden character to change a number to text - hence left justified

and if part number not found
=IFERROR(INDEX('new MASTER LIST'!A:A,MATCH(C2,'new MASTER LIST'!C:C,0)),"No Match")

compare (2).xlsx
ABCDE
1FINDDESCRIPTIONPART NUMBERNEW FIND#
21block2222
32potatoe4444
43recycle5555
54sign1111
65car3333
7897No Match
8No Match
9No Match
10No Match
old MASTER LIST
Cell Formulas
RangeFormula
E2:E10E2=IFERROR(INDEX('new MASTER LIST'!A:A,MATCH(C2,'new MASTER LIST'!C:C,0)),"No Match")
Cells with Conditional Formatting
CellConditionCell FormatStop If True
C2:C7Cell ValueduplicatestextNO


compare (2).xlsx
ABC
1FINDDESCRIPTIONPART NUMBER
21sign111
32block222
43car333
54potatoe444
65recycle555
7
8
9
new MASTER LIST


on dropbox - only for a few days
 
Upvote 1
Solution

Forum statistics

Threads
1,226,452
Messages
6,191,127
Members
453,641
Latest member
enfkkviesm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top