Forum Discussion

RonenBitmn's avatar
RonenBitmn
Copper Contributor
Jan 04, 2021

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...
Formulas and Functions
lori_m's avatar
lori_m
Iron Contributor
May 07, 2025

For future reference: based on comments below, a method to spill any HYPERLINK formula of the form,

=HYPERLINK(link_location,friendly_name)

is to wrap link_location in an INDEX function:

=HYPERLINK( 
    INDEX(link_location, ROW()-ROW(RC)+1, COLUMN()-COLUMN(RC)+1), 
    friendly_name 
)

Note: this formula is given in RC-notation so that RC refers to the formula cell e.g. G4. In the general case link_location and friendly_name may be 2D calculated arrays and the formula may be freely moved around

Resources