Take Column Value from another Table

[LD]

Dear All,

I have the following situation:

Table 1

 Col 1             Col 2              Col 3

 Name 1        Data XX          Data XY

 Name 2        Data 11          Data 12

 Name 1        Data XA          Data YY

 ....

Table 2

 Col 1             Col 2

 Name 1        INFO 1

 Name 2        INFO 2

....

I would like to create another Col in table 1 with information of Col 2 of Table 2 considering the correlation of Colmns 1 into the two tables, that is:

Final Result

Col 1             Col 2              Col 3             NEW Col

 Name 1        Data XX          Data XY        INFO 1

 Name 2        Data 11          Data 12         INFO 2

 Name 1        Data XA          Data YY        INFO 1

 ....

Thank you!!!!

LD

[harshnathani · Accepted solution]

Hi @LD ,

Create a relationship.

Lookup Column =

RELATED(Table2[Col 2])

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)