+ Reply to Thread
Results 1 to 5 of 5

formula needed with a combination of criteria

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    55

    formula needed with a combination of criteria

    I'm struggling with a formula. I want to determine if some criteria lead to a "Yes" statement or that a "NO" statement must result as the outcome of the formule. In attached spreadsheet I explain the problem. Hopefully someone can help me out with the formula!
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,134

    Re: formula needed with a combination of criteria

    Hi,

    Please enter the following formula in G2 & check if it yields the desired result:

    =IF(AND(C2=2013,D2=N2,F2=O2),"YES","NO")


    Regards,
    Chandra

    Please click on ‘ * Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.

  3. #3
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,067

    Re: formula needed with a combination of criteria

    In G2

    =IF(AND(C2=2013,ISNUMBER(MATCH(1,INDEX(($N$2:$N$7=D2)*($O$2:$O$7=F2),0),0))),"YES","NO")

    Copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,492

    Re: formula needed with a combination of criteria

    Also......Try this array formula which requires Ctrl+Shift+Enter instead of just Enter.

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  5. #5
    Registered User
    Join Date
    01-28-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: formula needed with a combination of criteria

    Hi Chandra, thanks for your reply. The problem is that the combination of D2 and F2 must occur in the table N2-O7. For instance the combination D9 and F9 (Frankrijk/X) can not be found in the table, so the outcome will be "NO". Your formula only compares single rows.

    Regards, Robert

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-16-2012, 09:57 AM
  2. Combination generator needed...
    By ej2012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2011, 09:07 PM
  3. combination generator needed
    By smiso24 in forum Excel General
    Replies: 16
    Last Post: 04-12-2010, 07:18 PM
  4. numbers combination help needed
    By notobo in forum Excel General
    Replies: 3
    Last Post: 05-27-2009, 12:18 AM
  5. Formula needed for 2 criteria
    By Sue in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2006, 08:44 AM

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