Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    128
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula Help (2003)

    Loungers

    I have the following formula in a conditional lookup - =OFFSET(course:Position,MATCH($E7,Position,0)-1,MATCH(F$6,course,0))="E"

    I need to add a third criteria called site - so that the condition matches three not two criteria - I've tried a few combinations to include "site" but keep getting errors

    Any thoughts?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula Help (2003)

    I'd need to see (a stripped-down copy of) the workbook to understand what your formula does.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    128
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help (2003)

    Hans,

    Thanks for the quick response - Please see sample attached

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula Help (2003)

    Thanks. I don't understand the relation between your question and the workbook. Could you please explain in words what you want to accomplish?

  5. #5
    2 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    128
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help (2003)

    Hans,

    What happens is training (or as I call them "Must do Units") requirements vary from site to site - different work locations

    In the planner I select the site, the position and the "Must Do units" - then in the Training matrix - I select the site and the position and the conditional format formula does its thing - so i need the formula to include the site in the conditional format.

    I hope that helps

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula Help (2003)

    Thanks, it wasn't clear to me that you meant conditional formatting when you wrote conditional lookup. Try this formula for the first condition formula in F7:

    =OFFSET(course:Position,MATCH($D7&":"&$E7,Site&":" &Position,0)-1,MATCH(F$6,course,0))="E"

    You must define the name Site as =Planner!$B$6:$B$34 (analogous to Position)

  7. #7
    2 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    128
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help (2003)

    Thanks again for your help

    Complements of the season

Posting Permissions

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