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