Add (hidden) columns into your Named Range with formulas like
Code:
ColumnRowNo = ROW()-HeaderRowNo
and
PositCnt=COUNTIFS(ColumnLDatarange,">0",ColumnRowNo,"<=" & [@ColumnRowNo]
To return matching value in column A for 1st occurrence of positive value in olumn L:
Code:
=INDEX(ColumnADatarange, SUMIFS(ColumnRowNo,PositCnt,1))