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

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