Address and hyperlink formula

[purlo]

I have this formula: =HYPERLINK("#"&"'Timespan'!"&ADDRESS(13,MATCH(A28,Timespan!$A$13:$AIK$13,0))," "&A28) I would like to add to it another ROW there it should search for A28 figure. Right now it search in this array: $A$13:$AIK$13,0 that is 13th row, but I would like to add another ROW.
Thank you

[purlo]

i attach and excel file, what i want to accomplish

[hemesh]

Its Number error from second sheet use below formula there
=IFERROR(INDEX(Sheet1!$A$1:$G$1,SMALL(IF(Sheet1!$A$1:$G$1<>"",COLUMN(Sheet1!$A$1:$G$1)),ROW(A3))),"") as array entered


and hyperlink formula as below
=HYPERLINK("#"&"'Sheet2'!"&ADDRESS(SUMPRODUCT((Sheet2!$A$1:$A$999=B1)*ROW($A$1:$A$999)),SUMPRODUCT((Sheet2!$A$1:$A$999=B1)*COLUMN($A$1:$A$999)))," "&B1)

[purlo]

can you explain or just show, how to this formula: =IF(INDEX(Timespan!$B$2:$AJD$2,0,ROW(O3))=0,"",INDEX(Timespan!$B$2:$AJD$2,0,ROW(O3)))
add additional row. now it shows results from row 2, but i want it to show from row 2 and row 3

[hemesh]

to use result of two rows use like this
=index function for first search&" "&index function for another search

suppose your first result is 28 and second is 45 above formula will give result as

28 45

[purlo]

Okey thanks. it works. but now i have adittiontal question.
i have this formula: =INDEX(Timespan!$B$2:$AJD$2,0,ROW(O59))&"; "&INDEX(Timespan!$B$3:$AJD$3,0,ROW(P59))&"; "&INDEX(Timespan!$B$4:$AJD$4,0,ROW(P59))
is it possible to remove this semicolon IF i dont have any figure in one of the arrays showed in the formula.
i want this semicolon to be shown only when there is what to segregate

[hemesh]

what results you are getting from formula could you share that part
like yes;;yes or there are numbers or what else you are getting from results of formulas

[purlo]

various results. Like names and so. so it looks like "John; ;" and "Mike; Luke;"