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 formulaand I've attached a sample document. I'd appreciate some help.![]()
=OFFSET(APR!$AA$5,0,0,MATCH("*",APR!$AA:$AA,-1),1)
Thanks
Bookmarks