Perhaps
=IF(COUNTIF(A1:A28,D1),"YES","NO")