See Debra Dalgleish's excellent explanation of Dependent Lists:

http://www.contextures.com/xlDataVal02.html


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"khwoz" wrote:

excel ver.5 I am trying to set up purchase list. The purchases need to be
id'd by a main group, a sub-group based on the main group selection & a 2nd
sub-group based on the 1st sub-group selection. A drop down works great for
the main group but I can't figure out how to make the next two work on the
result/selection of the first one. Any ideas?