If you had 5 Data Validation columns
and 10 unique choices for each selection
then you would have to make lists for 10000 items.
In my example I limited the number of choices
so only 50 rows of data need to be entered.
Excel 2003 List and Excel 2007 Table
will give you dependent drop-down lists
without formulas:
http://www.freefilehosting.net/download/3d4f5