Utradeshow
Well-known Member
- Joined
- Apr 26, 2004
- Messages
- 802
- Office Version
- 365
Hi all,
I am Using a zip program to find nearest zip code. Then I use a VLOOKUP to populate cells. I have to convert the result of the zip code program to work with the VLOOKUP. I tried using VALUE function which works on zips with the full 5 digits and doesn't work with the ZERO leading Zipcodes. Then the TEXT function works with the "ZERO" zips and not the regular zip codes???? Any Suggestions?
I am Using a zip program to find nearest zip code. Then I use a VLOOKUP to populate cells. I have to convert the result of the zip code program to work with the VLOOKUP. I tried using VALUE function which works on zips with the full 5 digits and doesn't work with the ZERO leading Zipcodes. Then the TEXT function works with the "ZERO" zips and not the regular zip codes???? Any Suggestions?