Hi Uwe,
Uwe Brauer <o...@mat.ucm.es> writes:
> Here is an example where the org-lookup-first method seems to fail
> #+TBLFM: $3='(org-lookup-first $2 '(remote(Table1A, @I$1..@II$1))
> '(remote(Table1A, @I$7..@II$7)))::$4='(org-lookup-first $2 '(remote(Table2A,
> @I$1..@II$1)) '(remote(Table2A, @I$7..@II$7)))::$5=vsum($3..$4);f2
You forgot to update the column numbers: the names to look for are now in
the column '2', and, the totals are now in column '8'. This should work:
#+TBLFM: $3='(org-lookup-first $2 '(remote(Table1A, @I$2..@II$2))
'(remote(Table1A, @I$8..@II$8)))
#+TBLFM: $4='(org-lookup-first $2 '(remote(Table2A, @I$2..@II$2))
'(remote(Table2A, @I$8..@II$8)))
#+TBLFM: $5=vsum($3..$4);f2
Bruno
