How to make Vlookup formula only a specific numbers in a range of data

[questforexcel]

Hi,

Below are the numbers from which I want my vlookup formula to pick only the first 3 digits.

However, if there is a "0" in the beginning of the formula, I'd like it to only pick the next 2 digits after 0.

Could you please help me in this formula assessment.

Currently, I've used the formula =IFERROR(VLOOKUP(LEFT(A98,3),'USPS - Zone & Rate Chart'!$B$4:$I$125,2,1),"")

However, for the ranges starting with 0, it returns the blank value.

01022-1174

01057-9616

01104-2628

<colgroup><col></colgroup><tbody>
</tbody>

 

[sandy666]

maybe

=IFERROR(VLOOKUP(--LEFT(A98,3),'USPS - Zone & Rate Chart'!$B$4:$I$125,2,1),"")

no real example - not tested