assuming that counties column A is alpha sorted
assume 132 counties

Formula in say - Cell G6 Then copy down

=Vlookup(F6,counties!A1:B132,2,False)

Vote Republican!

"Dominique Feteau" wrote:

I have a helper sheet called "counties". In it is a list of all the counties
in Illinois (column A) and the district they belong in (column B). I have a
small macro that converts a .csv file to the format that I like, but i'd
also like for it to look in Column F of the Data Sheet, match the county and
insert the corresponding district in Column G.

Anyone help me out with this? Thanks