Convert Zip Code to County

[Guest]

Our company uses counties to determine sales territories, so I often need to
take a database of addresses and ad a column for the county, and then
manually populate the cells. I then use a pivot table to divide the
information up into sales territories. Is there a way to have the cells in
the county coumn populate automatically by referencing the zip code if I have
another fixed database with all of the zip codes and their associated
counties?

 

[Guest]

Yes Michael, the VLOOKUP function should do exactly what you want......
something like.....

=VLOOKUP(A1,ZipCountyDB,2,FALSE)

where A1 is the Zip you want to look up, and ZipCountyDB is two columns
listing the Zips in the left column and their corresponding counties in the
right.

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thanks Chuck - That's exactly what I was looking for!