Results 1 to 8 of 8

Return value after searching 3 col's of zipcodes

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2011
    Location
    Victoria Australia
    MS-Off Ver
    Excel 2000
    Posts
    5

    Return value after searching 3 col's of zipcodes

    Hi everyone, I know the basics but this is beyond me.

    I run a small courier Co and charge a fixed rate between towns in set zones, I have 3 columns of Zip-codes (Postcodes here in Oz) corresponding to the zones and wish to input two codes and return a dollar value based on what zone they are in.

    My criteria is for example:
    Any two codes from zone one is $20.00
    Any two codes from zone two is $22.50
    Any two codes from zone three is $25.00
    Any one code from zone one and either of the other zones is the $ value of the higher zone plus $8.00 and the same for between zones two and three (the higher value plus $8.00)

    I hope this makes sense and is do-able.

    Oscar
    Last edited by Oscar Fox; 05-13-2011 at 10:04 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1