Description: I have a list with names and last names and in another sheet, i have that function who when i write a name, in another box apears the last name. Some of the names and last names work but there is a lot of them that for example if i have "Alejando Paredes" and "Javier Llorca" when i put "Javier" it apear "Paredes" but if I put "Alejandro", it apear "Paredes" aswell. Steps to Reproduce: 1.Create a list with names and last names with 20 of them 2.Create another sheet anf put there the function SEARCHV 3.use that list for the function Actual Results: You will see that not all the names have their last names correctly Expected Results: Show the name and last name correctly Reproducible: Always User Profile Reset: Yes Additional Info: .
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
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.
from the description I would guess: Sort the source-list ascending by Name and the »bug« is solved! ⇒not a bug?
(In reply to Werner Tietz from comment #3) > Sort the source-list ascending by Name and the »bug« is solved! Not necessarily; it depends on the arguments used for this specific case. We would need the file, in order to review whether the data is sorted or not, and to review whether the arguments of the function correspond to that. Having said that, there are reports not yet resolved, especially for unsorted data.