Notifications
Clear all
Power Query
2
Posts
1
Users
0
Reactions
105
Views
Topic starter
Hi, I have 2 columns. ColumnA and ColumnB. I want to lookup each item of ColumnA in whole ColumnB and if there is any match return "Found". I tried List.Contains({[ColumnB]},[ColumnA]) but it doesn't work since it compares cells in only in the same row.
Posted : 27/05/2018 6:02 am
Topic starter
I found the answer here;
https://stackoverflow.com/questions/50414941/count-if-or-match-in-another-column-in-same-table
Posted : 27/05/2018 9:25 am
