Forum Discussion
bullius
Helper V
Helper VIf column contains values from column in another table...
Hello I would like a column that shows whether or not a column in Table2 contains values that are in Table1. Table1 Value New Column A TRUE B FALSE C TRUE D FALSE ...
jahida
Impactful Individual
Impactful IndividualI know KGrice's formula worked but it does seem a tad clunky... you could consider this as a slightly cleaner alternative (since the CONTAINS function exists exactly for this purpose):
Column = CONTAINS(Table2, Table2[Value], Table1[Value])
