Find if the text in one table is in another table.

[Syndicate_Admin]

Hello everyone
I would need help with the following.
I have two tables that are not related:
Table 1: Products with their ingredients.
Table 2: List of Ingredients.
I need to know which of the products in Table 1 have any ingredients from Table 2.
---------------------------------------------------------------------------------------------------------------------------------------

Table 1
List of products, where one of their text-type comments are the ingredients of the comma-separated product,

Table 2
List of ingredients.

[Syndicate_Admin]

It can't be, tables don't have the same column number. Also the coicidence is not exact.

[shreyamukkawar]

Try using INTERSECT Dax..