• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA or Formula? to assign a Zone based on driving miles

S

steve400243

Member
Hello, I have a Code that i found online and am using to get 'google distance' for driving miles between 2 zip codes. I am trying to get a VBA, or cell formula, to assign a zone number for every 5 miles in distance. Please see the attached, Cell B6 would be where i need this to populate. This will need to go up to 200 miles. Thanks for your time and help.
 

Attachments

  • Milage test.xls
    114.5 KB · Views: 3
Thank you very much Hui, This is working for me. I was using an index, and Match, but could not get it to work right. I appreciate the formula!
 
You must log in or register to reply here.
Back
Top