* Thorsten Grothe <i...@th-grothe.de> wrote: > 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.
You might be interested in: http://sachachua.com/blog/2015/01/getting-data-org-mode-tables/ or https://github.com/tbanel/orgaggregate I'd give it a try with orgaggregate since it provides a lot of reference methods. Did not try it by myself - it's on my todo list for the weekend (again) :-) -- mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode: > get Memacs from https://github.com/novoid/Memacs < https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github