Re: [O] Sverweis like function for orgtbl

[Karl Voit]

* Thorsten Grothe <address@hidden> 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