View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
coloradio coloradio is offline
external usenet poster
 
Posts: 3
Default formula to auto populate zip when city is typed in Excel

I have a data base with multiple small cities, they each have only one zip
code, and I would like it if there is a formula that would auto populate the
zip i.e. If C4=Montrose then C5=84070.
Thanks for the help