Replace Column Value With Data From Another File's Column

[shaheer]

I have two sets of data that are similar to this:

File A

Name	Height	Colour	TPM	Manager
Amy	6	Red	10	Kris
Bob	6	Green	10	Yuri
Carl	6	Blue	10	Wendy
Derrick	5	Purple	10	Anna

File B

Name	Age	APR	TPM	Director
Amy	20	3	10	Jeffrey
Elay	21	5	10	Manny
Carl	22	3	10	Tiago
Fred	20	2	10	Veronica

Wherever a name from file A occurs in file B, I want to replace the manager in file A with the one in file B. For example, an output here would be: 

Name	Height	Colour	TPM	Manager
Amy	6	Red	10	Jeffrey
Bob	6	Green	10	Yuri
Carl	6	Blue	10	Tiago
Derrick	5	Purple	10	Anna

As you can see, Amy and Carl's managers have been updated. (EDIT) Note; In one file, the column name is Manager whereas in the other it is Director (EDIT) How do I go about doing this? 

[Felipe_Ribeir0 · Accepted solution]

Hi @shaheer 

One way of doing this, just be careful with duplicated names. If you have any ID field related to these names to use as join key, it would be better.