Comparing two columns and filling another column w...

[JeremiBen]

Hi, 

I have a column where the information is linked to a value in the same tab. I would like the information to be automatically filled with the information on the other line. 

For example on the screenshot, I would like to have John Doe in the cell for Brandon Walsh when I update the john Doe line.  

I tried with the automation but couldn't figure out how to do that. 

Thank you very much...