Thread: zip code to city, state function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
xcelentform
 
Posts: n/a
Default zip code to city, state function

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

Reply With QuoteReply With Quote