We got a new system at work for inventory and now have new part numbers.
I have a file with the old part numbers and one with the new numbers and need to combine the two in one sheet. For example:
[70250133][SLEEVE,BEARING,5",SAWC,498D772G004] is the old number and part, number being in B1 and part in C1. And on the other file I have
[1055017][SLEEVE,BEARING,5",SAWC,498D772G004] is the new number, number being in
A4251 and part in B4251. Is there a formula to help put these two(and the thousands of other parts) together even being in separate files?