Help - Creating a variable validation list.
I am trying to create a variable drop down list.
I have a reference Table containing names and multiple ph # for the names.
Example:
A B C D
1 Name Smith, A
2 Ph #
3
4 Hm# Cell Other
5 Doe, J (555)555-1234 (555)568-1234 (555)568-9876
6 Smith, A (555)555-2345 (555)568-2345 (555)568-8765
7 Jones, K (555)555-3456 (555)570-3456 (555)570-7654
8 Martin, R (555)555-4567 (555)457-4567 (555)457-6543
Scenario: If you enter a name Smith, A (A6) into B1 -from which has a validation list of A5:A8. In B2, you would automatically have a drop down list with the multiple numbers from B6:D6 you could choose from. If you enter a name Martin, R (A8) into B1 -from which has a validation list of A5:A8; In B2, you would automatically have a drop down list with the multiple numbers from B8:D8 you could choose from.
I have been trying to come up with a variety of nested functions to create this, but am currently unable to. I know its there and I will be obvious when I see it done, but right now I am unable to create it.
Any ideas?
Bookmarks