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. ...
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.