Old Parts To new parts

Originally Posted by shg

Have you tried VLOOKUP?

How would i use it to match AND replace the numbers? I can get it to tell me there is a match but not have it replace it with the corresponding part from Sheet 1.