Code not returning data i want

[erimhast83]

ActiveCell.FormulaR1C1 = _
"=IF(AND(RC[2]=""DUCK,DONALD"", RC[2]=""RABBIT,ROGER"",RC[2]=""MOUSE,MINNIE"",RC[2]=""DUCK,DAISY"",RC[12]=""WHITE,SNOW"",RC[2]=""DOE, JOHN"",RC[2]=""DOE, JANE""), ""DUCK,DONALD"",""DOO, SCOOBY"")"

The above code should bring back DUCK,DONALD but is bringing back DOO,SCOOBY.

Can anyone see what I am doing wrong in my code?

Thank you,
E.

 

[Jonmo1]

Why would that return Duck,Donald?

AND requires ALL criteria to be true.
It is not possible for ALL the criteria in your AND to be true.
Just looking at 2 criteria, it is impossible for RC[2] to be Duck,Donald AND Rabbit,Roger.

I think you mean for that to be an OR.

 

[Joe4]

I think maybe you meant to use OR instead of AND.
In order for AND to return true, ALL of the things you are checking for must be true.
There is now way a cell can be equal to both "DUCK,DONALD" and "RABBIT,ROGER" at the same time. It is either one or the other, or neither.
For an OR statement to be true, only one of your checks need to be true.