lookup value in another column

Hi, llamasarefun . CR LOOKUP VALUE is basically equal to AMOUNT IN LOCAL CURRENCY * -1 in any given row of your table (sign aside). Lets suggest that you would like to check if your table has more than one row with such amount. Then try this

let
    Source = your_table,
    lu_column = List.Buffer(Source[CR LOOKUP VALUE]),
    yes_no = 
        Table.AddColumn(
            Source, "YN", 
            each 
                if List.Count(List.PositionOf(lu_column, [CR LOOKUP VALUE], Occurrence.All)) > 1
                then "YES"
                else "NO"
        )
in
    yes_no