You could use a vlookup but it would be huge. Look at usps.com

--
Don Guillett
SalesAid Software

"xcelentform"
wrote in message
...

Is anyone aware of a function that will read a zip code and result in a
city and state? Example: IF(B25=53520,"Brodhead,
WI",IF(B25=53521,"Katmando, WI",........ Any thoughts? I would type it
up, but there are over 19,999 variations that I am considering for the
50000-69999 area codes that I think will apply to my list. Thanks, Dave


--
xcelentform
------------------------------------------------------------------------
xcelentform's Profile:
http://www.excelforum.com/member.php...o&userid=16889
View this thread: http://www.excelforum.com/showthread...hreadid=543550