Sure. You need a worksheet with the zips and towns listed on it, then you
can use a vlookup. See this for a tutorial:
http://www.officearticles.com/tutori...excel.htm#boss
*******************
~Anne Troy
www.OfficeArticles.com
"accessnovice" wrote in message
...
I have created a sheet in which I am entering addresses. I created a drop
down list for the seven zip codes I am working with. Is there a way to
have
excel automaticall y enter the corresponding town in the adjacent cell
after
I choose a zip code?