I have a data validation table that contains multiple cities. When a city is selected from the drop down menu, I want a value to be placed in a cell next to it.

How can I do this?
Population.png