How to filter multiple columns for a list of text values

[Anonymous]

I have a text search problem which I cannot find a good solution for. 

I have a table "Code Table"  with 5 text columns: Code 1, Code 2, Code 3, Code 4, Code 5. I want to search each of these columns for a list of 27 values in another table, "Value Table". If one of these values matches anything in the code columns then I want to create a "Results" column showing TRUE/FALSE. 

Important note - the results table can link to any of the code columns. I am essentially using the results table as a filter. 

I could do this with a nested IF statement, but that's ugly. Is there a simpler way to do this? 

Example of the data structure: 

Code 1Code 2Code 3Code 4Code 5Results

a1		b2			TRUE
b2					TRUE
		c3			TRUE
			c3		TRUE
	d4				TRUE
z26					FALSE
		y25			FALSE

Results

a1

b2

c3

d4

[Zubair_Muhammad · Accepted solution]

@Anonymous 

You can use this Custom Column.

please see the attached file's query editor as well

=List.ContainsAny(Record.ToList(_),ValuesTable[Results])