Zip - State - County
 

I have a file that lists all 49,918 zip codes and their state and county. I
want to create a spreadsheet that will allow a user to enter a Zip code and
then the state and county populate based on that. could VLOOKUP be used for
something like this? I have used vlookup in a long time. does anyone know of
a good site that give a refresher? thanks in advance

Yes, vlookup would be perfect

http://www.contextures.com/xlFunctions02.html



Regards,

Peo Sjoblom

"dandigger" wrote:

I have a file that lists all 49,918 zip codes and their state and county. I
want to create a spreadsheet that will allow a user to enter a Zip code and
then the state and county populate based on that. could VLOOKUP be used for
something like this? I have used vlookup in a long time. does anyone know of
a good site that give a refresher? thanks in advance

http://www.techonthenet.com/excel/formulas/vlookup.htm

http://www.contextures.com/xlFunctions02.html

http://www.automateexcel.com/index.p...08/15/excel_fo
rmula_vlookup_function_example

http://www.exceltip.com/excel_tips/L...rmulas/112.htm
l

http://www.barasch.com/excel/vlookup.htm

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a file that lists all 49,918 zip codes and their
state and county. I
want to create a spreadsheet that will allow a user to
enter a Zip code and
then the state and county populate based on that. could
VLOOKUP be used for
something like this? I have used vlookup in a long time.
does anyone know of
a good site that give a refresher? thanks in advance
.