>>> "UB" == Uwe Brauer <o...@mat.ucm.es> writes: >>> "BB" == Bruno Barbier <brubar...@gmail.com> writes: >> Hi Uwe,
>> Uwe Brauer <o...@mat.ucm.es> writes: >>> so the question is what is equivalent of VLOOKUP in org. >> Did you check these lookup functions in the Org manual? >> (info "(org) Lookup functions") I ask differently why does the following solution not work #+Name: table1 | 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: final | Name | Some | ResSh1 | |--------+------+--------------| | Smith | 4 | [22, 19, 18] | | Miller | 4 | [22, 19, 18] | | Wick | 4 | [22, 19, 18] | |--------+------+--------------| #+TBLFM: @2$3..@>$3=remote(table1,@2$7..@>$7) But this solution does, what does @@#$7 mean? #+Name: final2 | Name | Some | ResSh1 | |--------+------+--------| | Smith | 4 | 22 | | Miller | 4 | 19 | | Wick | 4 | 18 | |--------+------+--------| #+TBLFM: @2$3..@>$3=remote(table1,@@#$7) -- Warning: Content may be disturbing to some audiences I strongly condemn Putin's war of aggression against Ukraine. I support to deliver weapons to Ukraine's military. I support the NATO membership of Ukraine. I support the EU membership of Ukraine. https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/
smime.p7s
Description: S/MIME cryptographic signature
