You could choose the category in a cell, then select from a dependent
list in the same cell. However, after you make that choice, you'd have
to clear the cell and start over, if you wanted to select a different
category or dependent item.

For example, in cell B2, you could select items from a list named
Produce. If you select Fruit, then the drop down in cell B2 would
change, to show a list of fruits.

To do this, in cell B2, enter this as the Data Validation formula:

=IF(B2="",Produce,INDIRECT(B2))

Herb wrote:
I have a list of categories and a secondary list of items associated with
each choice on the category list. I would like to be able to select a
category and then a selection from the secondary or dependent list but have
only that value show up in the column. There is only one column and I don't
want to display the category. All the examples I have seen would place the
category selection in column 1 and the dependent choice in column 2.
Any help would be much appreciated!


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com