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") Bruno. > > I came up with the remote command that results in a similar result, (I did > not want to use third party packages like > orgtbl-aggregate. > > #+begin_src > #+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: table2 > | Name | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh2 | > |--------+-----+-----+-----+-----+-----+--------| > | Smith | 8 | 3 | 5 | 8 | 9 | 33 | > | Miller | 9 | 4 | 6 | 9 | 3 | 31 | > | Wick | 1 | 5 | 9 | 1 | 2 | 18 | > |--------+-----+-----+-----+-----+-----+--------| > #+TBLFM: $7=vsum($2..$6);f2 > > #+Name: final > | Name | Some | ResSh1 | ResSh2 | Final | > |--------+------+--------+--------+-------| > | Smith | 4 | 22 | 33 | 59 | > | Miller | 4 | 19 | 31 | 54 | > | Wick | 4 | 18 | 18 | 40 | > |--------+------+--------+--------+-------| > #+TBLFM: $3=remote(table1,@@#$7)::$4=remote(table2,@@#$7)::$5=vsum($2..$4);f2 > #+end_src > > > The syntax with @@#$7 look cryptic to me, but I found it somewhere and it > works > if somebody can suggest a simpler command that is closer to VLOOKUP I would > be grateful > > Thanks and regards > > Uwe Brauer > > -- > 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/
