Results 1 to 5 of 5

Creating a variable validation list

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2006
    Posts
    3

    Question Creating a variable validation list

    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?
    Last edited by Kurt Sasse; 10-10-2006 at 05:35 AM. Reason: Rephrase question

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1