From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Preserving the geometry of a table range
Date: Mon, 27 Aug 2012 14:33:29 +0200
Message-ID: <CALn3zogrJSpNJaNxxO9iywf-veWaXaH0UB+MGxiq3dARBo-8TA@mail.gmail.com>
References: <87lih25ejt.fsf@syk.fi>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:39162)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1T5yVd-0008N2-V3
	for emacs-orgmode@gnu.org; Mon, 27 Aug 2012 08:33:44 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1T5yVY-0000Is-1Z
	for emacs-orgmode@gnu.org; Mon, 27 Aug 2012 08:33:37 -0400
Received: from mail-lpp01m010-f41.google.com ([209.85.215.41]:37986)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1T5yVX-0000IQ-Pu
	for emacs-orgmode@gnu.org; Mon, 27 Aug 2012 08:33:31 -0400
Received: by lahd3 with SMTP id d3so2486985lah.0
	for <emacs-orgmode@gnu.org>; Mon, 27 Aug 2012 05:33:30 -0700 (PDT)
In-Reply-To: <87lih25ejt.fsf@syk.fi>
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: Jarmo Hurri <jarmo.hurri@syk.fi>
Cc: emacs-orgmode@gnu.org

Hi Jarmo

On Sun, Aug 26, 2012 at 8:54 AM, Jarmo Hurri <jarmo.hurri@syk.fi> wrote:
> I ran into this problem while trying to make a contribution by
> implementing functions corresponding to vlookup and hlookup in
> traditional spreadsheets.  I have only used relatively basic properties
> of org, so there might be a simple solution that I just don't know.

Only now I see that this second part with the actual problem of your
original post is still unanswered. Does this help?:

| key (ordered) | val |   | val (ordered) | key |
|---------------+-----+---+---------------+-----|
|             8 | foo |   | bar           |  42 |
|            42 | bar |   | foo           |   8 |
#+TBLFM: $5 = '(nth (position $4 '(@<<$2..@>$2) :test 'equal) '(@<<$1..@>$1))

Michael