Note: I don't think that a lookup function can fix this
problem because there are multiple counties in different
states with the same name. The solution cannot solely
rely on the county name because several states have the
same county names in them.

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.