How to use a lookup function in a cell table referencing an other table?

[Anonymous]

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

[Anonymous]

I really searching official resource for information.

Find only this one:

I hope this will help with your tables problems.

Jon