Forum Discussion
bgaspers
Nov 13, 2021Copper Contributor
LAMBDA malfunction with HYPERLINK
I'm running into an odd malfunction using LAMBDA to encode a hyperlink function. This function: LAMBDA(JumpRange,DisplayText,HYPERLINK(MID(CELL("filename"),FIND("[",CELL("filename")),(FIND("]",CE...
bgaspers
Nov 15, 2021Copper Contributor
PeterBartholomew1 SergeiBaklan Thanks for the insights, it probably is the case that HYPERLINK doesn't behave like a "normal" Excel function. I guess this is what happens when you roll new functionality out to the broader community, who then start to uncover the edge cases.
rolhoh
Mar 14, 2022Copper Contributor
thanks for sorting out - i run into the same problem