Thread: formula to auto populate zip when city is typed in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kassie Kassie is offline
external usenet poster
  
Posts: 37
Default formula to auto populate zip when city is typed in Excel
Name the range where you have your city names and zip codes - eg ZipCodes
In C5 enter =IF(C4="","",VLOOKUP(C4,Zipcodes,2,FALSE)

Kassie
"coloradio" wrote in message
...
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


Reply With QuoteReply With Quote