questforexcel
Board Regular
- Joined
- Jan 18, 2019
- Messages
- 128
- Office Version
- 2013
- Platform
- Windows
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.
<colgroup><col></colgroup><tbody>
</tbody>
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>