Forum Discussion
LAMBDA malfunction with HYPERLINK
I played with the formula to get a form I have become accustomed to
= LAMBDA(JumpRange,DisplayText,
LET(
filename, CELL("filename"),
start, FIND("[",filename),
end, FIND("]",filename) + 1,
docName, MID(filename,start,end-start-1),
HYPERLINK(docName&JumpRange, DisplayText)
)
)and then uploaded it to a named Lambda function, to give the worksheet formula
= GOTOλ("Target",Text)As was pointed out, the result is not a hyperlink. If a hyperlink is also introduced via the Insert menu, it will determine the link destination. The GOTOλ function only sets the visible text.. My thought is that the hyperlinks do not really form part of Excel but, rather, connects to some external web functionality.
Yes, actually that's not about lambdas themselves. That's about name manager and environment for the lambdas.
The interesting thing is that, in the past, I used Name Manager to access the calculation engine because it was more effective than the worksheet. It could access the EVALUATE macro command and perform array calculation flawlessly without having implicit intersection cripple the calculation.
In this situation the position is reversed; hyperlinks on the sheet work whereas they fail as Named formulas. My partially thought through idea was that hyperlink processing is not a function of the Excel calculation engine but something separate linked to document interfaces.
PeterBartholomew1 actually we may consider that as a bug. Perhaps in lambdas environment it will be found another way for deploying functions; or name manager will be improved to meet new realities; or we will live with that.