Results 1 to 2 of 2

Dependant Drop Down List + No Duplicates

This is a discussion on Dependant Drop Down List + No Duplicates within the Excel Questions forums, part of the Question Forums category; Hi, I have used aladin's idea from the Hall of Fame board on dependant drop down lists but it allows ...

  1. #1
    Board Regular
    Join Date
    Apr 2006
    Location
    Sydney
    Posts
    649

    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,200

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