One guess .. peep through Debra Dalgleish's page at:
http://www.contextures.com/xlDataVal13.html
Excel -- Data Validation --
Dependent Dropdowns from a Sorted List
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Matt H." <Matt wrote in message
...
Trying to create a formula that when depending on what word is selected
from
a list I created, then another list will appear in that cell