Hi,

Am Fri, 5 Feb 2016 04:54:27 -0800 (PST) schrieb :

I need the new part number and the old part number side by side so...
[1055017][70250133][SLEEVE,BEARING,5",SAWC,498D772G004], being in A1-C1.

Also they're in random order on both files. It wouldn't match up if I sorted them in any order and tried to copy and paste, due to new parts in the new item number file as well.

try:
=INDEX([Book1.xlsx]Sheet1!$A:$A,MATCH(C1,[Book1.xlsx]Sheet2!$B$1:$B$5000,0))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional