You can either have both workbooks open and match from the edited workbook to the original or, for convenience, copy the original worksheet to the same workbook as the edited worksheet. That would be my preference.
So, let's assume you copy the original data to a new sheet in the edited list workbook. Once it's copied, close the original workbook to put it out of harm's way. Double click on the tab and change the name to "original", no quotes.
Now, in B2 in the edited sheet, type the formula: and press Enter. It should return the address for the matching name. Then copy the cell and paste it to all the other (populated) cells in column B. When they have been populated and calculated, select all the cells, copy them and, without selecting any other cell, Paste Special | Values. That will overwrite the formulae with values. You can now delete the copied original data worksheet.
Regards, TMS
Bookmarks