B2数组公式:
=IF(C2="","",IF(COUNT(FIND(ROW($1:$10)-1,A2)*FIND(ROW($1:$10)-1,C2)),"Y","N"))
按CTRL+SHIFT+回车键结束公式,下拉.