Forum Discussion
Solved
List.Contains to Lookup for a value within the same table
Hello, I'm trying to come up with the M code to find if the value from one field is also in another field (equivalent of a VLOOKUP in Excel) within the same table. The table has two columns (A and B)...
Write it like
if List.Contains(List.Buffer([PreviousStepName[Column B]), [Column A]) then "Yes" else "No"
--Nate
that's amazing, it's working.
Thanks!