Results 1 to 8 of 8
  1. #1
    Join Date
    May 2006
    Posts
    178

    Unanswered: look ups that have conditions

    Hey ladies and gents,

    I have a problem that i am having difficulty solving. I have 2 sheets and im trying to use mileage information in one and see if it falls between a certain range then in the other so returns corresponding team information and populates a cell. I have attached a sample to this thread so you can see what i mean. Can someone please point me int he right direction?

    Many thanks

    Aboo
    Attached Thumbnails Attached Thumbnails Teams.jpg   searchinfo.jpg  
    Last edited by aboo; 10-22-08 at 19:36.

  2. #2
    Join Date
    May 2006
    Posts
    178
    anybody out there? or was my post confusing?

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. I have been sick, so not much help. It would be easier if you attached an .xls file (zipped). In the file be sure to indicate what you expect the result to be from the formula (just type in the number and put an explanation). That will give us an idea of the actual setup and we can test it.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  4. #4
    Join Date
    May 2006
    Posts
    178
    Hi Rich,

    Thank you for your reply. I hope that you are fully recovered from your illness.

    Basically the attached spreadsheet contains 2 populated sheets (sometimes the sheets contain alot more info).

    1st tab "searchinfo"
    2nd tab "teams"

    searchinfo has a blank column "C"

    I want to search the "teams" sheet usins the data from the 1st sheet.

    ie.

    the cell "C2" should contain "TEAM A"
    and cell "C3" should contain "TEAM C"

    Because the search should find the route where there mileage falls into and returns the value.

    I hope im making sense. again thank you for your help.


    Aboo
    Attached Files Attached Files

  5. #5
    Join Date
    May 2006
    Posts
    178
    Am i still talking in tongues? lol

    Shades? did i scare you away?

  6. #6
    Join Date
    Oct 2003
    Posts
    1,091
    No. I serve full time for our church body, as seminary president, mission developer, and extended pastoral training. And now I am filling a pastoral vacancy Fri-Mon, about 250 miles away. So travel, study, phone conferences, and training take up almost all my time.

    Basically I have no days off ... until sometime in February.

    Now you know why I retired as Excel user.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  7. #7
    Join Date
    May 2006
    Posts
    178
    Shades i wish there were more like you, alot of people dont give the time of day on forums. please accept my apologies if i sounded impatient.

    Regards

    Aboo

  8. #8
    Join Date
    Oct 2003
    Posts
    1,091
    No apologies necessary. I thoroughly enjoyed working with Excel, when I was doing it full time. At times now when I miss it, I take a trip through the boards. Unfortunately I can't spend the time setting up solutions.

    The good news... there are several excellent helpers here, far better than me.

    Wish you well with this.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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