On Sat, 25 Nov 2006, Dave Peterson wrote:

Don Wiss wrote:
Just how do I turn "Index" & MenuSuffix into the range value?

Debra Dalgleish shows how to create dependent lists:
http://contextures.com/xlDataVal02.html

Thanks Dave. I had once seen that page before. I found the process
confusing. But with a simple improvement to the tables backing these lists,
I came up with:

On my main input I have a column with this copied down:
=IF(V12="",A$3,INDIRECT(V12))

Then on my comparison sheet with two input cells I found I could use names:
=IF(SubMenu1="",A2,INDIRECT(SubMenu1))
=IF(SubMenu2="",A2,INDIRECT(SubMenu2))

Don <www.donwiss.com (e-mail link at home page bottom).