From mboxrd@z Thu Jan 1 00:00:00 1970 From: Thorsten Grothe Subject: Sverweis like function for orgtbl Date: Mon, 16 Feb 2015 15:01:05 +0000 (UTC) Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:40458) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1YNNAv-0003V0-Cn for emacs-orgmode@gnu.org; Mon, 16 Feb 2015 10:01:33 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1YNNAr-0002uD-2f for emacs-orgmode@gnu.org; Mon, 16 Feb 2015 10:01:29 -0500 Received: from plane.gmane.org ([80.91.229.3]:45471) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1YNNAq-0002tp-Sv for emacs-orgmode@gnu.org; Mon, 16 Feb 2015 10:01:25 -0500 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1YNNAk-0004FP-BK for emacs-orgmode@gnu.org; Mon, 16 Feb 2015 16:01:18 +0100 Received: from ip-37-201-62-240.hsi13.unitymediagroup.de ([37.201.62.240]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 16 Feb 2015 16:01:18 +0100 Received: from info by ip-37-201-62-240.hsi13.unitymediagroup.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 16 Feb 2015 16:01:18 +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 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