Completing table using values coming from a second table and common references.

[julianveda]

Hi community,

I have a hard time trying to put the information in column "F3" from the first table in the same column "F3" of the second table. There is a column in both tables that could be used as common key. The ides as you can see in the image is respect all the other cells in table two, just to put those missing values from table 1 into the table 2:

Thanks for reading

[binuacs · Accepted solution]

@julianveda more dynamic way of doing this with the Join tool

[julianveda]

Thank you @binuacs and @ShankerV  for your solutions 🙂