# formula needed with a combination of criteria

1. ## 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!

2. ## 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. ## 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

4. ## 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.``

5. ## 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

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

#### 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