Re: [O] Sverweis like function for orgtbl

[Michael Brand]

Hi Thorsten

On Mon, Feb 16, 2015 at 4:01 PM, Thorsten Grothe <address@hidden> wrote:
> I got this table:
>
> | Menge (x) | P(x) |   E(x) |   K(x) |  Gewinn |
> |-----------+------+--------+--------+---------|
> |         0 |   20 | 0.00   | 140.00 | -140.00 |
> |        10 |   18 | 180.00 | 180.00 | 0.00    |
> |        20 |   16 | 320.00 | 220.00 | 100.00  |
> |        30 |   14 | 420.00 | 260.00 | 160.00  |
>
> and would like to find the highest value in the column "Gewinn" = 160 go
> two cells left to E(x), read out the value (420) and put this in a remote
> orgtbl. This is something similar to Sverweis in Excel.

For a solution with a table formula see
(info "(org) Lookup functions")
or
http://orgmode.org/manual/Lookup-functions.html
It contains also a link to a tutorial.

Michael