Hi all,

Sometimes when we receive a large census file, we are only provided the zip code. However, we need to determine the state for records. Using the first (3) digits of the zip code provided this is possible.

For instance: Iowa: 500-529, Minnesota: 550-569, etc. (for all 50 states there is a correspondence)

So, what I need to do:

1) Search for the header "State"
2) IF State is found, skip this process
3) IF it isn't found, run a process that goes through a column where the zip codes are located and be able to determine the state based on the first three digits (refer to up above)
4) Create a new column with State as the header and place it to the right of Zip code, this is where the states would go.

I'd love to explain more if need be.

Thanks everyone.