You need to also create a Dynamic Named Range for column A so that you can grow that column too...
After you've done that (it should be same rows as the DATA named range)... then try:
=INDEX(colA,SMALL(IF(Data=0,ROW(Data)-MIN(ROW(Data))+1),ROWS($A$1:$A1)))
where colA is dynamic named range name for column A corresponding to DATA range.
confirmed with CTRL+SHIFT+ENTER and copied down.
Bookmarks