I have a cell that contains multiple product names separated by commas. The cell can have 1 to 15 product names. I then have a list of specific product names on another worksheet in the same workbook. How would the formula be written to do the following: if any of the product names in cell "A1" match anything in the list on the other worksheet return a "yes" otherwise return a "no"?
Bookmarks