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