I am trying to type a formula in a table cell as Excel function.
In Excel, I use these two formulas:
INDEX($C$5:$Z$43,MATCH(H3,$B$5:$B$43,0),MATCH("SDR "&J3,$C$3:$Z$3,0)+1)
VLOOKUP((K2),$B$5:$B$43,1,TRUE)
In AutoCAD, I try:
Table(140699412923696).Evaluate(lookup(A3,$A$4:$A$42,True))
Table(140699412923696).Evaluate(index($B$4:$Y$42,match(A3,$A$4:$A$42,0),Match(C3,$B$2:$Y$2,0)+1))
But the results always are the same: #######.