Results 1 to 13 of 13

Extract Data from Matrix

Threaded View

  1. #1
    Registered User
    Join Date
    06-22-2008
    Posts
    12

    Extract Data from Matrix

    Greetings:

    I'm sorry to just jump in with my problem, but I'm not even sure what to call what I'm trying to do, so just let me ask...

    I'm running a small messenger company and I've got a geographic area divided into five zones: 1,2,3E,3W,& 4

    Deliveries within 1 zone will be charged for one zone.
    Deliveries from Zone 1 to Zone 2 will be charged for 2 zones. Etc.

    I've got a list of zones in my From column and also in my To column.

    I need to write a formula that will give my customers the Zones Charged in a seperate cell.

    I learned how to do something like this back in school, but don't even know what to call it anymore. Maybe it's some kind of comples IF function.

    I'd sure appreciate anyone who can help me figure out how to do this.

    FREE Deliveries to anyone in Long Beach, CA to the winner!!!

    I'm attaching a chart to show what I need done.

    Thanx in advance.

    Michael Doughty
    M&M Messenger
    Attached Images Attached Images
    Last edited by rylo; 06-22-2008 at 09:12 PM. Reason: Revise Post Title

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