have found answer to main part of problem: (note: can leave soft
line-returns in cell for easier view, array: cntrl-shift-enter)

=HYPERLINK(IF(ISNA(INDEX(ROW($CH$130:$CH$1868)-ROW($CH$130),MATCH(TRUE,ISERROR($CH$130:$CH$1868), 0))),"",
"#"&CELL("address",OFFSET(INDIRECT(SUBSTITUTE(SUBS TITUTE(CELL("address",BE13),"$",""),ROW(),"")&INDE X(ROW($CH$130:$CH$1868),MATCH(TRUE,ISERROR($CH$130 :$CH$1868),0))),$AA$3,0))),"err")

example in other entry for Indirect is for starting row number.. have a
problem finishing this task for getting the following indirect to work, for
columns. if no answer available here, will repost. thanks.

=HYPERLINK(IF(ISNA(INDEX(ROW($CH$130:$CH$1868)-ROW($CH$130),MATCH(TRUE,ISERROR($CH$130:$CH$1868), 0))),"",
"#"&CELL("address",OFFSET(INDIRECT(SUBSTITUTE(SUBS TITUTE(CELL("address",BE13),"$",""),ROW(),"")&INDE X(ROW($CH$130:$CH$1868),MATCH(TRUE,ISERROR($CH$130 :$CH$1868),0))),$AA$3,0))),"err")