Thank you, Ed. This information helped, but I am still struggling with my
3rd list which is dependent upon the combination of the 1st and 2nd list.
The 1st list has unique values, and the 2nd list has values that can apply to
multiple values in the 1st list, so the 3rd list has to look at both the 1st
list and 2nd list value. In the example below, the 3rd list has to have a
data validation (Indirect) formula that points to a list for CVS Card Stock
or Kohls Card Stock, based on what is chosen; it can't just point to a Card
Stock list.

Example:
1st List = CVS, 2nd List = Card Stock, 3rd List = CVS Card Stock Displays
1st List = Kohls, 2nd List = Card Stock, 3rd List = Kohls Card Stock Displays




"Ed Ferrero" wrote:

Hi Lisa,

Go to http://www.edferrero.com/ExcelCharts...2/Default.aspx
and download 'Cascading Cell Validation' (page 2, I think)

That sample has 2 dependent levels, plus an explanation. To see a sample
with 3 dependent levels, download
http://www.edferrero.com/Content/Cas...Validation.xls

Ed Ferrero
www.edferrero.com