Kristi Waski
New Member
Good morning.
I would like to take my source cell which contains a complete business address, and have it find the zip code within that complete business address and compare it to another reference table. In that reference table are zip codes and the city that is associated. I would like to find the zip code in the source, and end up with the city.
I have found multiple examples of the reverse using wild cards, just nothing that will work for my needs.
Because the source data is not standard (it sometimes included a PO Box or a Room number) I couldn't just trim the data or utilize text to columns on a comma.
123 Main St., Smalltown, MI, 12345, USA
I want to look at the above and have the result be "Smalltown" based on the zip code "12345"
Thank you in advance.
Warmest regards
KW
I would like to take my source cell which contains a complete business address, and have it find the zip code within that complete business address and compare it to another reference table. In that reference table are zip codes and the city that is associated. I would like to find the zip code in the source, and end up with the city.
I have found multiple examples of the reverse using wild cards, just nothing that will work for my needs.
Because the source data is not standard (it sometimes included a PO Box or a Room number) I couldn't just trim the data or utilize text to columns on a comma.
123 Main St., Smalltown, MI, 12345, USA
I want to look at the above and have the result be "Smalltown" based on the zip code "12345"
Thank you in advance.
Warmest regards
KW