Forum Discussion
Look up tables
You can use LOOKUPVALUE to get the ID from table 2 onto table 1
ID = LOOKUPVALUE(Table2[ID],Table2[Email],Table1[Email])This will pull the ID from table 2 onto table 1 only where the email matches.
My ID's start at 1 just bacause I assigned an index column for the example.
Would it work if you build a list of all the unique emails from both tables then join it to the tables?
Emails =
DISTINCT(
UNION(
DISTINCT(Table1[Email]),
DISTINCT(Table2[Email])
)
)
Then you can just use the email from the Emails table.
Hi there,
Actually i have already something like that in place, the 2 tables are actually linked to each other. However i would like to have a numeric value cause in the future I would like to build a Venn diagramm and from my understanding I need numerical values to do that.
Thanks,
Ale
You can use LOOKUPVALUE to get the ID from table 2 onto table 1
ID = LOOKUPVALUE(Table2[ID],Table2[Email],Table1[Email])This will pull the ID from table 2 onto table 1 only where the email matches.
My ID's start at 1 just bacause I assigned an index column for the example.
