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