Zip - State - County

[Guest]

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

 

[Guest]

Yes, vlookup would be perfect

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



Regards,

Peo Sjoblom

 

[Jason Morin]

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

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

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

http://www.exceltip.com/excel_tips/Lookup_Formulas/112.htm
l

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

HTH
Jason
Atlanta, GA