Skip to Content
Former Member
Oct 20, 2007 at 12:40 AM

Creating a Formula to pull a unique ZIP CODE from a range????????


Post Author: robertr

CA Forum: Formula

I have a list of employee that have unique zip codes tied to their address. The problem is that we need to add the County to the address. There are two separate zip code table that list all zip codes and counties in the USA. The issue that the zip codes ae in two tables.

ZIP_START (75201)

ZIP_END (75212)

I need a formula tha would map for example zip code 75204 within the these two tables. The zip code field name in the employee list is ZIP_CODE. This way I can be assured that ALL zip codes within the ZIP_CODE field of the employee list map correctly to the ZIP_START and ZIP_END tables and return the correct county.