Data Validation with Indirect and Name Manager, created with Index or Offset functions

I was Created A Name Manger by using Formula as

MyList1 - =Sheet1!$A$1:$A$8
MyList2 - =Sheet1!$A$1:INDEX(Sheet1!$A:$A,MATCH("zzz",Sheet1!$A:$A))

And Created Data Validation List By using formula - =INDIRECT(B1) in Cell C1

So when I used MyList1 in Cell B1 the List showing well In Cell C1
But when I used MyList2 in Cell B1 the List not showing any thing why?

See the attached file

INDIRECT is very "picky".

An alternative is to use CHOOSE.

Put the range names in some cells...

X1 = MyList1
X2 = MyList2

Then, as the source for the drop downs use:

=CHOOSE(MATCH(B1,X1:X2,0),MyList1,MyList2)

You're welcome. Thanks for the feedback!