Dependant Drop Down List + No Duplicates

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Dependant Drop Down List + No Duplicates

  1. #1
    Board Regular
    Join Date
    Apr 2006
    Location
    Sydney
    Posts
    649
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Dependant Drop Down List + No Duplicates

     
    Hi,

    I have used aladin's idea from the Hall of Fame board on dependant drop down lists but it allows for duplicate entries in the second list, which I don't know how to stop.

    At the moment B8:B27 has a drop down list with 4 options when one is selected it populates C8:C27 with the respective lists.

    The data is on another sheet in named ranges. heres what the validation looks like now

    cell B8 has =KPA [the named range of the 4 choices)

    cell C8 has
    Code:
    =INDIRECT(VLOOKUP(B8,LookupTable,2,FALSE))
    The named range LookupTable has the range KPA along with the named range for the second lists, as the names in the KPA list don't match with the names of the second list.


    I hope that made sense!!

    Thanks for any help,

    Jason

    P.S. If it's an easier solution im happy to add a macro that checks for duplicates and just has a msgbox error saying no duplicates allowed.

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com