Hello,

Trying to work on some Data Validation with dependency lists in Excel 2000. I can do this all day long with 2002 and up, yet I'm having trouble with my 2000.

I'll have a named range drop down list in A1. I want A2 to be populated with the named range (list) of what I've chosen from the A1 list. Although, when I input the formula =INDIRECT(A1) in DV/List, it equates to an error. Anybody know about this in xl 2000?

Like I said, I've done this in 2002. I'm hoping that I've just overlooked something here.

Btw, the named range is a dynamic named range, using an INDEX/MATCH combo to go from row 2 to the last row w/ data in it.