jimsim31 - This does work fine in Excel 2007. A few tips: Make sure that the zip codes in your address list are formatted as 'text', as shown in the video. Also, if the zip codes in your list are in Zip + 4 format, use the formula =VLOOKUP(LEFT(D2,5),ZipList,2,False) so only the first 5 digits are used in the lookup function. And finally, check that there are no non-printing characters in the zip codes, which occurs sometimes when importing from another application. Hope this helps ...
thanks but next could you show Wilson's addresses
1112nigel 1 year ago
jimsim31 - This does work fine in Excel 2007. A few tips: Make sure that the zip codes in your address list are formatted as 'text', as shown in the video. Also, if the zip codes in your list are in Zip + 4 format, use the formula =VLOOKUP(LEFT(D2,5),ZipList,2,False) so only the first 5 digits are used in the lookup function. And finally, check that there are no non-printing characters in the zip codes, which occurs sometimes when importing from another application. Hope this helps ...
bjhughesfs 2 years ago
Thanks, it works now. Adding the Left function fixed it.
jimsim31 2 years ago
I tried this in Excel 2007 and all I get is #NA's for distance in the address list. Any ideas?
jimsim31 2 years ago