I have one issue. Currently I am getting some data from other people, and their excel have address and city.
I need something that will recognize which city have some zip code, instead of me manually adding it via drop down lists (currently I have drop down list, and when I get city i need, i use drop down option to get zip code for that city).
E.g. Sacramento is 94203, Los Angeles is 90001 , Denver is 80201
It's that simple for me, I just have 1 zip code for 1 city. But I would like that somehow it recognize the zip code just "lookup" from one field. 90% i am sure that other people always type "Denver" or "Los Angeles", not something like mistype or use "LA" or "L.Angeles" ...
I need something that will recognize which city have some zip code, instead of me manually adding it via drop down lists (currently I have drop down list, and when I get city i need, i use drop down option to get zip code for that city).
E.g. Sacramento is 94203, Los Angeles is 90001 , Denver is 80201
It's that simple for me, I just have 1 zip code for 1 city. But I would like that somehow it recognize the zip code just "lookup" from one field. 90% i am sure that other people always type "Denver" or "Los Angeles", not something like mistype or use "LA" or "L.Angeles" ...
