Forum Discussion
Hyperlink function do not support Dynamic Arrays
Hi, tried a very simple sheet where cell a1..a3 are links and cells b1..b3 are friendly names the formula hyperlink(a1:a3,b1:b3) shows the hyperlinks correctly but not the friendly names anyone ha...
I will have to remember to also test on the web version.
As for the XMATCH that seemed to be part of the 'trick' to make it work but I will have to try the ROW(). In my actual case it was even more complicated because I wanted a TRANSPOSE to also happen so the link spill was in a row while the link targets was in a column.
As per latest response, I think you can try entering in e.g. H2,
=HYPERLINK(INDEX("#"&ADDRESS(ROW(A1#),COLUMN(A1#)),ROW()-ROW(H2)+1,1),B1#)