Perhaps you might also want to try the sample file* (link below)
which contains a working implementation of your intent:
http://www.savefile.com/files/6614201
DependentLists_haitch2_misc.xls


*File is derived from Debra's sample: DataValDynamic.xls
at her: http://www.contextures.com/xlDataVal02.html
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--