Excel | Adapt Hyperlink Formula -

iv'e searched , found here on stackoverflow within thread, snippet of code posted comment user:1532334 works wish achieve, seek adapt row part of formula capture coulmn1=seq no instead of row number , appreciate assistance.

rows: b1=seq no, b2=code snippet below, b3= address

code:

=(hyperlink(indirect(address(row(),column()+1)),"link" & row())) 

b2 result= "link" & b1

there might simpler way this, i've used address , indirect functions reference column value of row formula in, similar how had hyperlink address feeding in.

=(hyperlink(indirect(address(row(),column()+1)),"link " & indirect(address(row(),1)))) 

when find new formulas on internet, try breaking them down , understanding how work. you'll pretty @ excel in no time @ all.