Forum Discussion
Solved
Return a value found in another table in any column
Dear community, I'm having a hard time finding the right formula to do the following: I have a Table 1 that contains references, one reference per row. I have a Table 2 that contains references spr...
pls try this
if your table2 is very large, then it would be better for you to write it like this
[ a =List.Buffer( List.Combine( Table.ToColumns(Table2))), b = if List.Contains(a,[#"Reference "]) then "Found" else ""][b]
shafiz_p
Super User
Super UserHi Clilly Connect both the table to power query. Keep table as it is. Create a new custom column in Table1 and write code as in the image below:
Checking each value of Table1 Reference with the Tab21 each 3 reference column, if matched, then it would be found else blank.
Hope this helps!!