Find and replace

With both files open, in the Original Part numbers workbook, enter this formula into cell D8

=VLOOKUP(A8,'[RECODE LIST.xlsx]Sheet1'!$A$1:$C$27,2,FALSE)

Copy down.

Then copy the results in column D, and use paste special > Values to paste over the original part numbers in column A. Then you can delete column D.

hi artj, so when u refer to Sheet 2, i assume u mean the 2nd workbook u uploaded? try this in A4 of the 2nd workbook:

=INDEX('[original part numbers.xlsx]Sheet1'!$A$8:$A$22,MATCH(C4,'[original part numbers.xlsx]Sheet1'!$C$8:$C$22,0))

if it's a totally new product not in the old list, do u do it manually then? if u want in to continue in sequence, u may try:

=IF(ISNA(INDEX('[original part numbers.xlsx]Sheet1'!$A$8:$A$22,MATCH(C4,'[original part numbers.xlsx]Sheet1'!$C$8:$C$22,0))),MAX($A$3:A3)+1,INDEX('[original part numbers.xlsx]Sheet1'!$A$8:$A$22,MATCH(C4,'[original part numbers.xlsx]Sheet1'!$C$8:$C$22,0)))

let me know if it works

benishiryo, is something wrong with your "y" and "o" keys? This is a forum, not txt messaging. There are many people on this forum whose first language is not English and who will not be familiar with the common txt message and chat room abbreviations. So please, keeping that in mind, spend the extra millisecond and write "you" instead of "u" etc. Thanks.

@npamcpp

hmmm that is some awesome advice u got there. but i couldnt find "txt" in the dictionary. and u should go for some anger management courses, come back here with courtesy, and i shall start listening. thanks
=)

@oeldere
yeah i do agree but this person here could certainly learn how to communicate better. i've seen him replying impatiently to a newcomer, post sarcasms like this.
which is a better way to tell people where the "log out" button is?
1) it's at the top right hand side of the forum.
2) are you blind or something? it's at the top right hand side of the forum.

benishiryo,

I'm sorry you feel that I'm a bad communicator. I said "please" and "Thanks" and tried to make my post sound friendly. All the same, I must have offended you. I'm sorry about that. I just want to ensure that your valuable contributions to this forum can be understood by all visitors, not just those who are familiar with the abbreviations commonly used in chat rooms and txt messaging (txt = sms = the messaging system on mobile phones).

I think my post and the way you read it is a classic example how written communication is mis-interpreted because other non-verbal communication is absent.

Be assured that I only had the best interest of the forum members in mind.

Kind regards.

@npamcpp

is something wrong with your "y" and "o" keys?

this is sarcasm. and since you were on the topic of not using abbreviations, "txt" is one of them. it should be "text". but as i mentioned to oeldere, i do agree with your statement that i should not use abbreviations. it's a habit i should change. so i'll take note of that.