Using list to check value of a cell

Thanks for the reply however both:

=IF(SUMPRODUCT(--ISNUMBER(FIND(MyList,D1))),"Y","N")
=IF(ISNA(LOOKUP(2^15,FIND(MyList,D1))),"n","y")

Now add a Y for all products weaver it contains a name from the list or not?