Forum Discussion
Solved
Matching Zip Codes to City
Hello, In one sheet titled "Crime rates in cities", I have cities and state names in a column such as: Adamsville, AL Alexander City, AL Aliceville, AL In the third sheet titled "Zip C...
Hi to all!
In this moment, you can't find the zip's code, because you have the whole name of state, and not the abbreviation of that state.
If you have a helper table with the abbreviation's of the states and aditional a helper column in Sheet "Zip Codes for cities", you can get all Zip Codes for the states.
Check file with an option. Blessings!
Hi to all!
In this moment, you can't find the zip's code, because you have the whole name of state, and not the abbreviation of that state.
If you have a helper table with the abbreviation's of the states and aditional a helper column in Sheet "Zip Codes for cities", you can get all Zip Codes for the states.
Check file with an option. Blessings!
Thank you!