multi variable vlookup if statement

[ajrogers33]

[TABLE="width: 798"]
<tbody>[TR]
[TD]Calendar Code[/TD]
[TD]Country[/TD]
[TD]Person[/TD]
[TD]Date[/TD]
[TD]Alex[/TD]
[TD]Mark[/TD]
[TD]John[/TD]
[TD]Mark and John, No Alex[/TD]
[/TR]
[TR]
[TD]ABB[/TD]
[TD]Antigua and Barbuda[/TD]
[TD]John[/TD]
[TD]10/01/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD]J[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABB[/TD]
[TD]Antigua and Barbuda[/TD]
[TD]Mark[/TD]
[TD]05/01/2017[/TD]
[TD][/TD]
[TD]M[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABB[/TD]
[TD]Antigua and Barbuda[/TD]
[TD]Alex[/TD]
[TD]04/14/2017[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABB[/TD]
[TD]Antigua and Barbuda[/TD]
[TD]John[/TD]
[TD]05/01/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD]J[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



I need to populate the 'Mark and John, No Alex' column with a 'YES' anytime that column A (calendar code) and column D (date) match, and shows up twice, one time with the Mark column populated with an 'M' and one time with the John column populated with a 'J'

 

[anglais428]

=IF(SUMPRODUCT(--(A4=$A$2:$A$5)*(D4=$D$2:$D$5)*(("M"=$F$2:$F$5)+("J"=$G$2:$G$5)))>1,"Yes","")