Mar 02 2023 07:03 AM - edited Mar 02 2023 07:04 AM
I want to spill an array that includes hyperlinks to various places in the workbook. In principle something like this:
=MAKEARRAY(3; 3;
LAMBDA(Row; Col;
HYPERLINK("#R" & Row & "C" & Col; "click")
)
)
But something is off. A 3x3 array is spilled with clickable hyperlinks in each cell - but the hyperlinks all take me to A1 (R1C1). Clicking on the bottom right cell should take me to R3C3, for instance. What's wrong?
Mar 04 2023 06:14 AM
Your formula works for me (Excel for the Web / English regional settings).
These formulas all lead to the same result:
=MAKEARRAY(3,3,LAMBDA(Row,Col,HYPERLINK("#R"&Row&"C"&Col,"click")))
=LAMBDA(Row,Col,HYPERLINK("#R"&Row&"C"&Col,"click"))(SEQUENCE(3),SEQUENCE(1,3))
=LAMBDA(Row,Col,HYPERLINK("#R"&Row&"C"&Col,"click"))({1;2;3},{1,2,3})
=HYPERLINK("#R"&{1;2;3}&"C"&{1,2,3},"click")
Mar 04 2023 09:12 AM
Mar 07 2023 08:13 AM