Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    List drop down dependency (2002)

    I have a list in Column 1 created from a validation rule (Data/Valadation/List/Selection/List) that allows users to select values from a drop down box. If I create another column in Column 2, how can I automate this column to default for each row based on the selection made from the drop down list box in Column 2?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: List drop down dependency (2002)

    Check out an example here

    Steve
    PS Welcome to the Lounge

  3. #3
    New Lounger
    Join Date
    Jul 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List drop down dependency (2002)

    Thank you.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: List drop down dependency (2002)

    You are very welcome

    Steve

  5. #5
    New Lounger
    Join Date
    Jul 2004
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List drop down dependency (2002)

    Hi Steve. When I attempted to perform this, I was expecting only one value to automatically populate in Column 2, not a drop down list. For instance, if someone chooses an orange, instead of an apple or banana from the drop down list in Column 1, then the price of $2 automatically populates Column 2 next to orange.
    Does this require a macro?

    Thanks for your help Steve.

    Mark

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List drop down dependency (2002)

    You can create a table somewhere that contains the items from column A and what you want in column B on another worksheet. For example In Sheet2:

    <pre> A B
    1 Apples $2.00
    2 Oranges $1.00
    3 Bananas $1.50
    </pre>


    Then in B1 of Sheet1 you could put a formula like this:

    <pre>=IF(A1<>"",VLOOKUP(A1,Sheet2!$A$1:$B$3,2,FALS E))
    </pre>


    Then copy this formula down the column.
    Legare Coleman

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: List drop down dependency (2002)

    Sorry, I thought you were looking for dependent lists, not a Lookup of a value.

    If Legare's solution is not what you need, please post back with additional details.

    Steve

Posting Permissions

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