Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Help with formula

    Hi Loungers,

    After some help (again)

    Trying to sort out a formula in C35 that matches the date in A33 along Row 2 and then the project name in B35 on.

    The result should return the value of 9408 for Feb 13 and Project 1, with the value changing when the date in C35 changes.

    I tried to get this to work in the formula in F35, but I've got something wrong.

    I hope that makes sence

    Any assistance woudl be approciated
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Try this for Project 1, then fill down:

    =INDEX($B$2:$AL$25,MATCH(B35,$B$2:$B$25,0),MATCH($ A$33,$B$2:$AL$2,0))

    I believe in your example you had the row/column index reversed.
    And, you need to look just at the project column for one match and just at the date row for the other.

    Alternatively:

    =VLOOKUP(B35,$B$2:$AL$25,MATCH($A$33,$B$2:$AL$2,0) ,FALSE)
    Last edited by kweaver; 2013-02-18 at 20:25.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Thanks for your help - that looks to do the job just right.

    Regards

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Verada,

    This formula: =OFFSET($B$2,MATCH($B35,$B$3:$B$24,0),MATCH($A$33, $C$2:$AL$2,0))
    Placed in cell C35 can then be filled down to do the trick. Please note that the sample worksheet had Feb 13 as the date but the number in your OP was for January and you have the dates restricted. HTH
    VeradaFormula.JPG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    It's really fun to see three solutions to one problem. Flexibility!! Options!!

  6. #6
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Thanks to all for your help - very much appreciated

    There seems to always be more than one way to skin a cat!


    Regards

    Verada

Posting Permissions

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