Forum Discussion
Excel EVAL() function does not support structured table references
I sometimes create complex lambda() to dynamically create a function string intended for EVAL(). The latest use required structured table references within that dynamically created function string. ...
maericson Try either =EVAL([@Column]) or =EVAL("Table1[@Column]"), depending on the desired outcome.
Did you try your suggestion? Neither work, they result in the same #NAME? error.
maericson Tested and proven to work, with different outcomes...
=EVAL([@Column])
=EVAL("Table1[@Column]")
EVAL: =LAMBDA(x,EVALUATE(x))The question is, how are you using the EVAL function? You still have not yet provided any sample data, or a legitimate example of the syntax you are attempting.