Thread: Creating two "interdependent, linked" cells on a spreadsheet

I'm not sure if I've used the right terms but here is what I'd like to do:

I have a spreadsheet (attached) and column B is for "account #" while column C is for "distributor". If possible, I would like for cell C2 to be populated (see list tab) with the appropriate distributor name based on what acct # is selected in B2.

And vice-versa; I would like cell B2 to be populated with the respective acct # when a specific distributor is selected.

Is there a way to make these two cells dependent on each other like this? Is what I'm asking clear enough?

Thanks,

BR