Hoping for cell fields to mirror each other

Hello,

I have a list of data in Excel with a mix of Client and Sales Rep records.

I have a column titled 'Sales Rep/Client' which will refer to the name of another record in the list. E.g. John Adams will be a Client, John Doe will be the Sales Rep.

I am hoping to enter the name of the Sales Rep/Client, and have the other persons record automatically update to contain this information.

So using my above example, I would want to enter John Adams into the 'Sales Rep/Client' column on John Does record. I am then wanting the 'Sales Rep/Client' column on John Adams' record to automatically update with John Does name.

Is this possible and if so how would I acheive this.

Thanks