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