"Contains" but for an entire column

[travslater]

Hello everybody

I have a list of text values in one table and I want to compare it to multiple columns in another table.

I'm hoping to search the whole table for any of the values in my first list and return something in that row if the lookup hits.

This would be similar to the Contains function, but for an entire column of data. 

Is there any language I can use, either with DAX or M code in the query? 

Anything helps, cheers!

[BeaBF]

Can you put a concrete case, in order to fix the answer?

B.