• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel help!

H

Horus

Platinum Member
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?
 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top