|It seems like the concept I suggested should still work.|
VLOOKUP can only look at one column, so perhaps you should go back to the orginal format of "county, state".
Let's say you put the "county, state" in Column N and the names of the salescritters in Column O, to get something like this:
F G ... N O
1 Project State Project County County, State SalesCritter
2 Alabama County2 County1, Alabama Joe
3 County2, Alabama Bob
Now "format" your VLOOKUP to combine your entries from Column G (project county) and Column F (project state), including the "comma space".
=VLOOKUP(G2 & ", " & F2, $N$2:$0$3000, 2, 0)
G2 & ", " & F2 will return the current version of "county, state" (County2, Alabama) and VLOOKUP will look up that string in Column N and return Bob.
The reason I suggested the Drop Downs in my first response was to eliminate the chance of a typographical error when the County and State names are entered in the cells. If either of those are spelt wrong, the VLOOKUP won't find them. Since it sounds like you are downloading the data, I guess that typos aren't an issue.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.