[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[the cryptic @@#$7] (was: equivalent of VLOOKUP (in ods) to org-table)
From: |
Uwe Brauer |
Subject: |
[the cryptic @@#$7] (was: equivalent of VLOOKUP (in ods) to org-table) |
Date: |
Sun, 08 Oct 2023 18:59:43 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) |
>>> "UB" == Uwe Brauer <oub@mat.ucm.es> writes:
>>> "BB" == Bruno Barbier <brubar.cs@gmail.com> writes:
>> Hi Uwe,
>> Uwe Brauer <oub@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
- equivalent of VLOOKUP (in ods) to org-table, Uwe Brauer, 2023/10/08
- Re: equivalent of VLOOKUP (in ods) to org-table, Bruno Barbier, 2023/10/08
- Re: equivalent of VLOOKUP (in ods) to org-table, Uwe Brauer, 2023/10/08
- [the cryptic @@#$7] (was: equivalent of VLOOKUP (in ods) to org-table),
Uwe Brauer <=
- Re: [the cryptic @@#$7] (was: equivalent of VLOOKUP (in ods) to org-table), Bruno Barbier, 2023/10/08
- Re: [the cryptic @@#$7], Uwe Brauer, 2023/10/08
- Re: [the cryptic @@#$7], Uwe Brauer, 2023/10/11
- Re: [the cryptic @@#$7], Bruno Barbier, 2023/10/12
- Re: [the cryptic @@#$7], Uwe Brauer, 2023/10/12
- Re: equivalent of VLOOKUP (in ods) to org-table, Bruno Barbier, 2023/10/08
- Re: equivalent of VLOOKUP (in ods) to org-table, Uwe Brauer, 2023/10/08