Forum Discussion
Stuznet
Helper V
Helper VFind matching value in another table and return with text string
Hi all, I've been looking around but couldn't find the simple solution to my work. So I have 2 tables and I need to perform lookup. If table1[Item] = table[Item] then it is "match" Table...
Apologies, I'm not understanding this I feel, but if you want to know if there is a match in another table, you could do this:
Column = IF(COUNTROWS(FILTER(ALL('Table2'),'Table2'[Item] = [Item]))>0,"Match",BLANK())
Greg_Deckler
Community Champion
Community ChampionApologies, I'm not understanding this I feel, but if you want to know if there is a match in another table, you could do this:
Column = IF(COUNTROWS(FILTER(ALL('Table2'),'Table2'[Item] = [Item]))>0,"Match",BLANK())
StuznetHelper V
Helper VThank you so much Greg_Deckler.