match string values in two diffrent tables

[soedholm]

Hi,

I have two tables what each have a column for email. I'd like to "match" the emails to get country value from the second table into the first. Situation is:

Table A:

email1

Table B:

email2

country

I'd like to say "If Email2 in Table B matches Email1 in Table A, add value in Table A for country". Is this possible?

[Vvelarde · Accepted solution]

hi @soedholm

Go to Edit Query -- Merge Query

+

Step 2: Click on expand

The result is 

[soedholm · Accepted solution]

Thanks!!!!

[v-sihou-msft · Accepted solution]

@soedholm

You can also use DAX to achieve your goal. Just add the calculated column in table A and use LOOKUPVALUE() to get the country column.

Country Column = LOOKUPVALUE(TableB[Country],TableA[Email1],TableB[Email2])

Regards,

[Vvelarde · Accepted solution]

hi @soedholm

Go to Edit Query -- Merge Query

+

Step 2: Click on expand

The result is 

[soedholm · Accepted solution]

Thanks!!!!