https://issues.apache.org/ooo/show_bug.cgi?id=105946
Anders Kvibäck <akva1...@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Version|OOo 3.1.1 RC2 |AOO 3.4.1 Resolution|--- |INVALID --- Comment #3 from Anders Kvibäck <akva1...@gmail.com> --- If you look into our documentation on the LOOKUP function it says; searchtable must be sorted, with numbers in ascending order ... Your searchtable is not sorted. There are other calc functions that you might use as VLOOKUP etc. I recommend that you use our Community Support Forum to ask your question. You can find the Forum at http://forum.openoffice.org -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.