Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to auto populate zip when city is typed in Excel
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" 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to auto populate zip when city is typed in Excel
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" wrote in message ... 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" 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions | |||
Excel 97 formula doesn't work in Excel 2003 | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Excel auto calculation formula question. | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |