https://bugs.documentfoundation.org/show_bug.cgi?id=159570
--- Comment #2 from ady <[email protected]> --- ATM I am writing this, the Summary is: Function "SearchV" don't work well FWIW, "SearchV" is Calc's function VLOOKUP(). ATM the Version field is 7.1.0.3. That version is no longer maintained, and later versions (e.g. 7.4) introduced changes to several lookup functions, especially when the data is unsorted. There have been reports of problems in such cases, some of them not yet resolved. I would suggest updating the version of LO and retesting. But, considering that there are other reports (that are not yet resolved) related to lookup functions when the data is unsorted, I'm not sure how much an update could help – it might depend on which exact LO version you end up testing. Attaching a minimal sample file might help to reproduce, but please keep in mind that it will be publicly available. -- You are receiving this mail because: You are the assignee for the bug.
