zip code to city, state function

[xcelentform]

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

[Don Guillett]

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

--
Don Guillett
SalesAid Software
[email protected]
"xcelentform" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>