Created attachment 133748 [details] The file whit the problem. Hello, I have a problem whit Vlookup, in the file you will see the sheet3 in the column B and C I have a formula for look the value in Column a. Column B looks in sheet2 in the same file and it doesn't works. Column C looks in a file xlsx and it works, whit errors. This is a very useful function, and if we can't trust it, then we have a very huge problem. I send the files, and I can see that is the same problem whit the bug 53277, but pleas do not dismiss it as RESOLVED INVALID
Created attachment 133749 [details] the other source of data
Thank you for reporting the bug. it seems you're using an old version of LibreOffice. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
It is still present in version 5.3.3
The worst is to see that when I open the file with WPS, Excel, PlanMaker, it show the perfect data.
On pc Debian x86-64 with master sources updated today, I could reproduce this. I noticed 2 things: 1) if I change the 4th parameter to 1 (true) it seems to work 2) if I copy paste a case on a brand new file, it works Notice, I don't say it'd work for every case, just a case I took. Indeed I create a brand new file with: in cell A1 and B1, I put: Assistance EDD adultes (9h30) in cell C1, I put: =VLOOKUP(B1;A1;1;0) it works In brief, I think there's some config on your file or on your cells/sheet, I don't know, which make things fail.
It is simply the REGEX enabled within the file. Menu Tools > Option > LO Calc : Enable regular expressions in formula. '(' is a REGEX. The special characters are . ^ $ * + ? \ [ ( { | If you want a (V/H)LOOKUP with one of these characters, disable the regex.