Determining the contents of a dropdown...

[coachdan]

Is there a way in Excel, without using VBA, to narrow the choices in a dropdown box based on the choice selected in another dropdown box. I know you can use the Lookup function to select one value from a dropdown and match it with one value from the lookup list, but the dropdown that determines the list has many items and each of those should populate the second dropdown list with many choices. Here is an example:

Category Source

Item1 SourceChoice1
SourceChoice2
SourceChoice3

Item2 SourceChoice4
SourceChoice5
SourceChoice6

An If Statement wouldn't work (I don't believe) because it would most likely exceed the nesting limitations. Any suggestions will be appreciated.

coachdan32

 

[Crystalyzer]

Is "Category" the first drop down and "Source" the second? If so go to

http://www.ozgrid.com/download/default.htm

and look for "MatchingLists.zip" This explains it all very well!

Lloyd

 

[coachdan]

That is correct. Thanks Crystalyzer, there are a lot of helpful tips there.

coachdan32