Forum Discussion

ecovonrein's avatar
ecovonrein
Iron Contributor
Apr 29, 2023

Syntax for calling Lambda via INDIRECT

Does anyone know the syntax for calling a Lambda via INDIRECT?  I can write   =Calipso!audit(1000)   but I cannot write   =INDIRECT("Calipso!audit")(1000)   nor   =INDIRECT("Calipso!audit(1...
excel
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Apr 30, 2023

JosWoolley 

Pretty similar?

= LAMBDA(text, EVALUATE(text))

Clearly the message is to read to the bottom before embarking upon a solution!

JosWoolley's avatar
JosWoolley
Iron Contributor
Apr 30, 2023

PeterBartholomew1 

 

Can you clarify? "Read to the bottom" of what precisely?

 

Regards

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Apr 30, 2023

    JosWoolley 

    I just meant scroll to the end of the replies.  It wasn't obvious to me that an old XLM command would work with a Lambda function developed some 30 years later so I simply set out to experiment.

    • JosWoolley's avatar
      JosWoolley
      Iron Contributor
      Apr 30, 2023
      But there is no trace in this thread of the post which your screenshot represents.

      Regards

Resources