> Uwe Brauer writes:
>#+TBLFM: $3='(org-lookup-first $1 '(remote(table1, @I$1..@II$1))
> '(remote(table1, @I$7..@II$7)))
Oops no I tried
$3='(org-lookup-first '(remote(table1, @1$7..@4$7)))
And that gave error
So thanks a lot
>#+TBLFM: $5=vsum($2..$4)
> IIUC, it seems to be the
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
Uwe Brauer writes:
"BB" == Bruno Barbier writes:
>> Did you check these lookup functions in the Org manual?
>>(info "(org) Lookup functions")
>
>
> Yes of course, but I am unable to obtain the same result as I do using
> the remote call.
Did you try something like this ?
#+NAME: ta
>>> "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
>>> "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")
Yes of course, but I am unable to obtain the same result as I do using
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")
Bruno.
>
> I came up with the remote command that results in a similar result, (I did
> not want to use third
Hi
I have regularly to deal with large tables, that I split in smaller ones and
then try to connect them.
I have to export the resulting big table to ods, and in the ods case, I have
several sheets and use the
VLOOKUP command, like this
#+begin_src
#+Name: table1
| Name | Ex1 | Ex2 | Ex2 |