Function to lookup Counties in another list
I am working a converting old county migration data into
a usuable form. I have one worksheet with counties and their respective states, and another worksheet with a listing of state and county FIPS information. For example: C8081coi! A B C D 1 2 To To From County Name From 3 St Co St 4 Abbr 5 6 7 ADAMS CO 8 DENVER CO Sheet0! A B C D 1 St Co County Name St Abbr 2 08 001 Adams CO 3 08 003 Alamosa CO 4 ... 5 6 7 8 I need to find a way to lookup a county name with its respective state in my master list of all counties. Note: The solution cannot solely rely on the county name because several states have the same county names in them. Thank you in advance. Alex |
Function to lookup Counties in another list
Check out Chip Pearson's web page on "Looking Up Data In Tables" at
http://www.cpearson.com/excel/lookups.htm. Also, do you have Microsoft Access available to consider using? I think joining various tables together becomes easier (and much faster) if you use a general-purpose database application. -- Regards, Bill "Ale" wrote in message ... I am working a converting old county migration data into a usuable form. I have one worksheet with counties and their respective states, and another worksheet with a listing of state and county FIPS information. For example: C8081coi! A B C D 1 2 To To From County Name From 3 St Co St 4 Abbr 5 6 7 ADAMS CO 8 DENVER CO Sheet0! A B C D 1 St Co County Name St Abbr 2 08 001 Adams CO 3 08 003 Alamosa CO 4 ... 5 6 7 8 I need to find a way to lookup a county name with its respective state in my master list of all counties. Note: The solution cannot solely rely on the county name because several states have the same county names in them. Thank you in advance. Alex |
All times are GMT +1. The time now is 06:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com