Hyperlink function do not support Dynamic Arrays

%3CLINGO-SUB%20id%3D%22lingo-sub-2028453%22%20slang%3D%22en-US%22%3EHyperlink%20function%20do%20not%20support%20Dynamic%20Arrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2028453%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3Etried%20a%20very%20simple%20sheet%20where%20cell%20a1..a3%20are%20links%20and%20cells%20b1..b3%20are%20friendly%20names%3CBR%20%2F%3Ethe%20formula%20hyperlink(a1%3Aa3%2Cb1%3Ab3)%20shows%20the%20hyperlinks%20correctly%20but%20not%20the%20friendly%20names%3CBR%20%2F%3Eanyone%20have%20a%20workaround%3F%3CBR%20%2F%3Ethanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2028453%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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 have a workaround?
thanks in advance

0 Replies