From mboxrd@z Thu Jan  1 00:00:00 1970
From: Thorsten Grothe <info@th-grothe.de>
Subject: Sverweis like function for orgtbl
Date: Mon, 16 Feb 2015 15:01:05 +0000 (UTC)
Message-ID: <mbt0nh$gns$1@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:40458)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) 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 <geo-emacs-orgmode@m.gmane.org>) 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 <geo-emacs-orgmode@m.gmane.org>) 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 <geo-emacs-orgmode@m.gmane.org>) 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 <emacs-orgmode@gnu.org>; 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 <emacs-orgmode@gnu.org>; Mon, 16 Feb 2015 16:01:18 +0100
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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