Lookup a value in a column RRS feed

  • Question

  • Hi, I have 2 columns. call them A and B. I want to lookup each item of A in whole B and if there is any match return "Found". I tried List.Contains({[B]},[A]) but it doesn't work since it compares cells in only one row.
    Friday, May 25, 2018 7:35 AM


  • I found the answer.

    I should take the column from previous steps. like if List.Contains(#"Changed Type"[B], [A]) then "Found", else ""

    • Marked as answer by ShahramG Saturday, May 26, 2018 1:33 PM
    Saturday, May 26, 2018 1:32 PM