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.

Attached Files

Data_Validation.xls (13.5 KB, 20 views)