See Debra Dagleish's pages on this:

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

--
Regards,
Tom Ogilvy

"Consulting Joan" <Consulting wrote in
message ...
My list is getting too long and I wanted to see if I can shorten it by
cresting subcategories. Another alternative is if there is a way to select
a
list based on critera, if the value is one, list A is displayed. otherwise
List B