Re: [the cryptic @@#$7]

2023-10-12 Thread Uwe Brauer
>>> "BB" == Bruno Barbier writes: > Hi Uwe, > Uwe Brauer 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..@

Re: [the cryptic @@#$7]

2023-10-12 Thread Bruno Barbier
Hi Uwe, Uwe Brauer 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))):

Re: [the cryptic @@#$7]

2023-10-11 Thread Uwe Brauer
> Uwe Brauer writes: > The ref "remote(table1,@2$7..@>$7)" targets a range, containing all fields of > colum 7. So, for each field, you get the same value: an array > containing all the field values: [22, 19, 19]. > See (info "(org) References"), in the section: >"Field coordinates in fo

Re: [the cryptic @@#$7]

2023-10-08 Thread Uwe Brauer
> Uwe Brauer writes: > The ref "remote(table1,@2$7..@>$7)" targets a range, containing all fields of > colum 7. So, for each field, you get the same value: an array > containing all the field values: [22, 19, 19]. > See (info "(org) References"), in the section: >"Fiel

Re: [the cryptic @@#$7] (was: equivalent of VLOOKUP (in ods) to org-table)

2023-10-08 Thread Bruno Barbier
Uwe Brauer writes: "UB" == Uwe Brauer writes: > "BB" == Bruno Barbier writes: >>> Hi Uwe, > >>> Uwe Brauer 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

[the cryptic @@#$7] (was: equivalent of VLOOKUP (in ods) to org-table)

2023-10-08 Thread Uwe Brauer
>>> "UB" == Uwe Brauer writes: >>> "BB" == Bruno Barbier writes: >> Hi Uwe, >> Uwe Brauer 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 follow