zip code to city, state function

Originally Posted by 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

Has anyone gotten this one figured out? Im interested in doing the same.