I have an Excel sheet with about 7000+ rows. Column A contains object names and column B contains location codes. In another sheet, there are 1000 rows with column A containing location codes and column B matched, proper location names that are more conventional.
What would be the most efficient way to replace (or match in another column) those 7000+ codes with display names so that the document can become more readable?
Here's a rough mockup
In other words: I'd like "Group" names from Sheet 2 to match every instance of the "Address" in Sheet 1. Sheet 2 in this case is simply a sort of a map legend.
Thank you