>>> "UB" == Uwe Brauer <oub@mat.ucm.es> writes:

> Hi again

>> Uwe Brauer <oub@mat.ucm.es> writes:


>> This works for me:

>> #+TBLFM: $2=if(typeof(remote(table2, @@#$7)) == 12, string(""), remote(table2, @@#$7)); E

> As you can see in the table2 the row Miller-and-Smith have been
> interchanged and so the final table ends up with incorrect values
> However, (as somebody else suggested some time ago) the following
> solution avoids that problem.

> #+begin_src 


> #+NAME: table3
> | Name   | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh1 |
> |--------+-----+-----+-----+-----+-----+--------|
> | Smith  |   2 |   3 |   4 |   6 |   7 |     22 |
> | Miller |   2 |  10 |   1 |   1 |   5 |     19 |
> | Wick   |   1 |   2 |   3 |  10 |   2 |     18 |
> #+TBLFM: $7=vsum($2..$6);f2

> #+NAME: table4   
> | Name   | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh2 |
> |--------+-----+-----+-----+-----+-----+--------|
> | Miller |   2 |   1 |   6 |   9 |   3 |     21 |
> | Smith  |   8 |   3 |   5 |   8 |   9 |     33 |
> | Wick   |   1 |   5 |   9 |   1 |   2 |     18 |
> #+TBLFM: $7=vsum($2..$6);f2

> #+Name: final
> | Name   | ResSh1 | ResSh2 | Total |
> |--------+--------+--------+-------|
> | Smith  |     22 | 33     |       |
> | Miller |     19 | 21     |       |
> | Wick   |     18 | 18     |       |
> #+TBLFM: $2='(org-lookup-first $1 '(remote(table3, @1$1..@4$1)) '(remote(table3, @1$7..@4$7)))::$3='(org-lookup-first $1 '(remote(table4, @1$1..@4$1)) '(remote(table4, @1$7..@4$7)))

> #+end_src


It seems that just adding ; E at the end of the line solves the problem


#+TBLFM: $2='(org-lookup-first $1 '(remote(sheet1, @I$1..@II$1)) '(remote(sheet1, @I$2..@II$2))); E 



-- 
I strongly condemn Hamas heinous despicable pogroms/atrocities on Israel
I strongly condemn Putin's war of aggression against Ukraine.
I support to deliver weapons to Ukraine's military. 
I support the EU and NATO membership of Ukraine.