Hello,
I'm attempting to pull in zones (value in collumn B) based off of the first three digits of a zip code.
The first three digits of the zip code will determine the zone.
For example, a zipcode of 00736, will return a zone of 45 (based on the table below).
<tbody>
</tbody>
Any tips for helping to create a formula for this? I have used a LOOKUP formula, however I have noticed sporadic errors in my data set as a result.
thank you all in advance,
Greg
I'm attempting to pull in zones (value in collumn B) based off of the first three digits of a zip code.
The first three digits of the zip code will determine the zone.
For example, a zipcode of 00736, will return a zone of 45 (based on the table below).
A | B | ||
Dest Zip | Zone | ||
<colgroup><col><col></colgroup><tbody> </tbody> | 007 | ||
006-007 | 045 | ||
009 | 045 |
<tbody>
</tbody>
Any tips for helping to create a formula for this? I have used a LOOKUP formula, however I have noticed sporadic errors in my data set as a result.
thank you all in advance,
Greg