Excel help!

[Horus]

I'm currently working on a project for work on Excel, and I have to input the country for a city name.

Example.

Row F Row G
MONTREAL CA
PORT ELIZABETH USA


Is there any way to make it so that I can have Excel auto-enter data? For example, assossiate Port Elizabeth with USA so that I don't have to enter it 50000000 times?

 

[NeoV]

You could have a list of the 'commonly used cities and the associated country

lets say on worksheet B, you have column A for your city names, and column B for your countries...

on your data entry page, in column A you would do your data entry (if you have a set list of cities you choose from you could get really fancy and use data validation to make it a drop down list), and in column B you would have a vlookup formula....like this
=vlookup(a2,sheet2!$a$1:$b$50,2,false) That assumes your list on 'sheet2' goes down to row 50. You could then just copy this formula down for each row that you put a city in for

pm me if you have any questions.