I have a problem when i'm trying to check the contents of a cell.

The list contain part name the refers to different models of the same product.

i.e.
List would say ABC and that would refer to Products ABC123 & ABC456.


=IF(ISNUMBER(FIND(mylist,d1)),"Y","N")
However, it only seems to pick up the 1st cell in the list.

I can use

=OR(EXACT(mylist,d1))

But then the list has to contain the the exact product (abc123, abc456, etc...)


Any idea how i can get this to work?