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