Hi Jarmo

On Sun, Aug 26, 2012 at 8:54 AM, Jarmo Hurri <jarmo.hu...@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

Reply via email to