formula to auto populate zip when city is typed in Excel coloradio 25.09.2006 15:52:02 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

Re: formula to auto populate zip when city is typed in Excel "Kassie" <kassie_kasselman[ at ]hotmaildotcomFIXDOT> 25.09.2006 16:00:10 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" <coloradio[ at ]discussions.microsoft.com> wrote in message news:44CFB490-8675-42B5-8E02-622EDF24911C[ at ]microsoft.com... [Quoted Text] >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

Re: formula to auto populate zip when city is typed in Excel coloradio 26.09.2006 15:35:01 I am sorry I thought this answered my question, but I guess I need a more detailed answer. What does the "","", represent in this formula, and when I name the city's and zip's do I name them individually or in a range? And when I name them do I define or create, Sorry I haven't used formulas for so long I've forgotten everything. The following is exactly what I need to do: If C1=Montrose then the zip will be 81401 if C1=Delta then the zip is 81416 if Olathe then the zip is 81425. I am not sure if this is possible, but I hope so. Thank you for your help Kelli "Kassie" wrote: [Quoted Text] > 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" <coloradio[ at ]discussions.microsoft.com> wrote in message > news:44CFB490-8675-42B5-8E02-622EDF24911C[ at ]microsoft.com... > >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 > > >

Re: formula to auto populate zip when city is typed in Excel "David Biddulph" <david[ at ]biddulph.org.uk> 26.09.2006 17:05:07 The first bit of the formula that begins =IF(C4="","",... says that if C4 is empty, the output will be empty, otherwise use the VLOOKUP function. For the range named Zipcodes, put your city names in the first column, and the zip codes in the second, then select the whole table (both column), & name the range with Insert/ Name/ Define ... note also that Kassie's formula needs an extra parenthesis at the end =IF(C4="","",VLOOKUP(C4,ZipCodes,2,FALSE)) -- David Biddulph "coloradio" <coloradio[ at ]discussions.microsoft.com> wrote in message news:A62B42FC-2B31-48E2-83A1-9669B2A4826F[ at ]microsoft.com... [Quoted Text] >I am sorry I thought this answered my question, but I guess I need a more > detailed answer. What does the "","", represent in this formula, and when > I > name the city's and zip's do I name them individually or in a range? And > when > I name them do I define or create, Sorry I haven't used formulas for so > long > I've forgotten everything. > > The following is exactly what I need to do: > If C1=Montrose then the zip will be 81401 if C1=Delta then the zip is > 81416 > if Olathe then the zip is 81425. > > I am not sure if this is possible, but I hope so. Thank you for your help > Kelli > "Kassie" wrote: > >> 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" <coloradio[ at ]discussions.microsoft.com> wrote in message >> news:44CFB490-8675-42B5-8E02-622EDF24911C[ at ]microsoft.com... >> >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