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