LAMBDA malfunction with HYPERLINK

bgaspers 

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.