How to "hard link" two adjacent cells to a data validation drop down list?
Hello to all!
As you can see on the attached Excel file I created a data validating drop down list (B2 -B5) and cannot figure out how to modify the list of the cells in the drop down list so that when I choose an item from the drop down list, not just the current cell but the two cells next right to it would also get updated.
For example, if I choose John from the drop down list, I'd like his building and apartment number also pop in once I let the mouse button go on John:
John A 1
So, maybe I should ask the question: How can you create a drop down list of not one column but two or three columns of lists?
Why I need this feature on the first place instead of merging the building and apartment number info in the first cell? So, that later I could do data sorting based on the building name or apartment numbers.
|