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
Bookmarks