[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Sverweis like function for orgtbl
From: |
Thorsten Grothe |
Subject: |
[O] Sverweis like function for orgtbl |
Date: |
Mon, 16 Feb 2015 15:01:05 +0000 (UTC) |
User-agent: |
Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) |
Dear Org-users,
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.
I found no predefined function for orgtbl, is it possible?
Thanks in advance!
Regards
Thorsten
- [O] Sverweis like function for orgtbl,
Thorsten Grothe <=