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