I received help with the attached file from other experts and just ran across an issue. The Sub StreetTeam should find all names in the "Macro Completed" sheet Column G that are in the "Names" sheet Column A, replace the value in Column E with the ShortName from the "Names" sheet and do some simple formatting. It works for some rows, then errors out saying apllication-defined or object-defined error. Seems like it starts referencing the wrong lookup values? I cant really tell. Any help is appreciated.