From mboxrd@z Thu Jan 1 00:00:00 1970 From: Karl Voit Subject: Re: Sverweis like function for orgtbl Date: Tue, 17 Feb 2015 11:14:50 +0100 Message-ID: <2015-02-17T11-11-14@devnull.Karl-Voit.at> References: Reply-To: Karl Voit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:35451) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1YNfBb-0004tN-9R for emacs-orgmode@gnu.org; Tue, 17 Feb 2015 05:15:24 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1YNfBT-0002SO-HV for emacs-orgmode@gnu.org; Tue, 17 Feb 2015 05:15:23 -0500 Received: from plane.gmane.org ([80.91.229.3]:57882) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1YNfBT-0002SI-A8 for emacs-orgmode@gnu.org; Tue, 17 Feb 2015 05:15:15 -0500 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1YNfBQ-0000yk-CN for emacs-orgmode@gnu.org; Tue, 17 Feb 2015 11:15:12 +0100 Received: from friends.grml.info ([136.243.234.19]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 17 Feb 2015 11:15:12 +0100 Received: from news1142 by friends.grml.info with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 17 Feb 2015 11:15:12 +0100 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org * Thorsten Grothe 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