Hi the attached spreadsheet has two tabs one with city's and one that corrects city names based on a lookup table
I want column A on the data sheet tab to change by looking at the table on the lookup sheet two and replacing the name with values from column B if needed.
Bookmarks