questforexcel
Board Regular
- Joined
- Jan 18, 2019
- Messages
- 128
- Office Version
- 2013
- Platform
- Windows
Hi All,
So my vlookup formula is referencing from a table where data exists and I am pulling it from the right column.
There are no spaces , or additional characters in any cell.
What I understand is the issue is that the lookup range and table array may still be in different formats. I read somewhere, that using text to columns to convert both the formats to general should help. I even did that, that did not work.
This is my formula.
=VLOOKUP(LEFT(A5,5),'Fedex Chart'!$B$4:$E$91252,4,0)
The table array looks like this
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
My lookup range are
<colgroup><col></colgroup><tbody>
</tbody>
I searched online for solutions to this problem, could not find an answer. Could you please help in.
Regards
So my vlookup formula is referencing from a table where data exists and I am pulling it from the right column.
There are no spaces , or additional characters in any cell.
What I understand is the issue is that the lookup range and table array may still be in different formats. I read somewhere, that using text to columns to convert both the formats to general should help. I even did that, that did not work.
This is my formula.
=VLOOKUP(LEFT(A5,5),'Fedex Chart'!$B$4:$E$91252,4,0)
The table array looks like this
Dest Zip/Postal Code | Post Code | Service Days | Zone |
500.00 | 500 | 3 | 6 |
501.00 | 501 | 3 | 6 |
502.00 | 502 | 3 | 6 |
503.00 | 503 | 3 | 6 |
504.00 | 504 | 3 | 6 |
505.00 | 505 | 3 | 6 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
My lookup range are
Postal Code |
2176 |
2635 |
2816 |
8505 |
8826 |
10598 |
<colgroup><col></colgroup><tbody>
</tbody>
I searched online for solutions to this problem, could not find an answer. Could you please help in.
Regards