Dependant Drop Down List + No Duplicates

[zzjasonzz]

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

=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.

 

[Brian from Maui]

See Aladin's revised method 1,

http://www.mrexcel.com/board2/viewtopic.php?t=8659