Created attachment 96205 [details] Table with shares updating new values I use Libreoffice 4.1.5 quite some time. The spreadsheet i work with is working fine in that version. Since i change to the 4.2.X version always problems with the lookup funktion. The bug ID 74594 doesn't help. i have the lookup table sorted ascending. It seems to me that lokkup is returning N/A Value always in diffrent cells. And in the 4.1.X version its always correct.
I think this is a duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=75642. Works now with: Version: 4.2.4.0.0+ Build ID: e1823627f35e4419880769fdd05acddbd0a9c25c TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-03-18_14:25:19 http://dev-builds.libreoffice.org/daily/libreoffice-4-2/ *** This bug has been marked as a duplicate of bug 75642 ***