[libreoffice-users] Re: LibreOffice Calc - Anomaly discovered in versions 4.2.8 and 4.4.6 - VLOOKUP function

Am 23.11.2015 um 18:10 schrieb Michele contabilmenteAG:
> Thanks, I solved the problem by entering the 4th argument to 0.
>
> The solution, as I look for now is effective.
>
> cordial greetings
>
> Michele Ras
>
> 2015-11-23 18:00 GMT+01:00 Andreas Säger <villeroy@t-online.de>:

You will get wrong matches or wrong #N/A errors if the "regular
expressions" option is ON and your search expressions contain certain
characters. With your own example
> CONTO TRANSITORIO PAGHE LL.DD.

will match any characters at the positions where the points are

You may get wrong positive matches when the "match whole cells" option
is OFF.
Search expression CONTO TRANSITORIO PAGHE will match at CONTO
TRANSITORIO PAGHE LL.DD.


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted