ethyn520 wrote:

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?

Define "put together". Given those two sample inputs, what do you want the
output to be?

FWIW, several years ago I wrote a fairly short VBA script that did pretty
much what you want, but rather than have duplicate entries for each item
(which I was specifically told to eliminate), it renamed the "ITEMNUMBER"
field in the database to "OLDITEMNUMBER" and created a new "ITEMNUMBER"
field. (Scripted because the item numbers were partly based on the physical
dimensions of the item, which had to be translated from the old format to the
new.)

--
No, let Courier Six carry the package.