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.

[TABLE="width: 89"]
<colgroup><col></colgroup><tbody>[TR]
[TD]01022-1174[/TD]
[/TR]
[TR]
[TD]01057-9616[/TD]
[/TR]
[TR]
[TD]01104-2628[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]

[/TD]
[/TR]
</tbody>[/TABLE]

 

[sandy666]

maybe

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

no real example - not tested