After searching everywhere I'm still unable to find a solution. I have two text documents, one is a list of names the other is coordinates. both documents start each line with an 8 digit code. I want to lookup 8 digit line code from File1 and copy the line contents to only code matches in File2. (File1) Only one occurence of Code / Name.Code: 136667ED ap1_01_a_ap1_01_rails_07 035B337C ap1_01_a_arrows_005 79546F82 ap1_01_a_centreline_010 0E1D31E7 prop_bush_med_02 (File2) Some have multiple Code copies, like 0E1D31E7. With different coordinates.Code: 136667ED -1294.6945,-2376.0317,21.8279 035B337C -1314.6719,-2721.7378,12.9467 79546F82 -1283.1066,-2529.9771,12.9635 0E1D31E7 1919.4160,-1814.3889,160.5210 0E1D31E7 1919.9885,-2628.2529,0.7537 0E1D31E7 192.0235,-2603.1790,4.9978 0E1D31E7 192.1050,4950.3540,389.4736 (Result) The 8 Digit code / name, copied into any code line match in file 2. The name only added to any match would suffice.Code: 136667ED -1294.6945,-2376.0317,21.8279 136667ED ap1_01_a_ap1_01_rails_07 035B337C -1314.6719,-2721.7378,12.9467 035B337C ap1_01_a_arrows_005 79546F82 -1283.1066,-2529.9771,12.9635 79546F82 ap1_01_a_centreline_010 0E1D31E7 1919.4160,-1814.3889,160.5210 0E1D31E7 prop_bush_med_02 0E1D31E7 1919.9885,-2628.2529,0.7537 0E1D31E7 prop_bush_med_02 0E1D31E7 192.0235,-2603.1790,4.9978 0E1D31E7 prop_bush_med_02 0E1D31E7 192.1050,4950.3540,389.4736 0E1D31E7 prop_bush_med_02 There are 75,000 names in File1, 370,000 lines of coordinates in File2. Also I've converted them in excel, In hope there was a way to lookup and update all with names.