What do you mean? You just have to change the city in A1. If that's not what you want, then show us the expected outcome. There has to be a lookup list somewhere for Excel to refer to.