Data validation lists from pivot table data

I have a similar problem, but the posted solution doesn't seem to work for me. I am using a dynamic named ranged, and think I have the right formula for my data validation list, but I'm still gettting blanks. Here's my formula

=OFFSET(APR!$AA$5,0,0,MATCH("*",APR!$AA:$AA,-1),1)

and I've attached a sample document. I'd appreciate some help.

Thanks