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

    Formula help based on two criterai

    Hi Loungers

    I'm after some help to develop a formula that will return a value based on a name and month and return a value.

    I think the attached will show what I'm trying to achieve - need to look at the date in the Worksheet and return the values in the Lead indicators worksheet.

    B7 in the Lead indicator worksheet for M004 should return a value of 4265 for May-13; 4122 for June-13 etc, and M005 3311 for May-13 etc

    I hope that makes sense

    Any help would be much appreciated

    The spreadsheet is generated from a database so will have numerous project, values etc
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Do you mean:

    =LOOKUP(2,1/(Worksheet!$C$10:$C$22=$A7)/(Worksheet!$B$10:$B$22=B$6),Worksheet!$R$10:$R$22)
    Regards,
    Rory

    Microsoft MVP - Excel

  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 Rory - yep that works just right.

    Thanks for your help

    Regards

Posting Permissions

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