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

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>:

> Am 23.11.2015 um 16:33 schrieb Michele contabilmenteAG:
> > Anomaly discovered in *versions 4.2.8 and 4.4.6* -
> > VLOOKUP function
>
> menu:Tools>Options>Calc>Calculation
> Regular expression = OFF
> Match whole cell = ON
>
> You leave out the 4th argument which means it defaults to 1. You want 0.
> VLOOKUP(x;range;2;0)
>
>
>
> --
> 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



-- 

http://contabilmenteag.wix.com/contabilmenteag-net
contabilmenteAG.net@gmail.com
contabilmenteAG@hotmail.it
Ras Michele Perito Agrario
Salita S.Barnaba 24d/18 16136 Genova Ge
Tel./Fax.:  010 213059
Tel.Mobile:3201107102

**** Riservatezza / Confidentiality **** In ottemperanza al D.Lgs. n. 196
del 30/6/2003 in materia di protezione dei dati personali, le informazioni
contenute in questo messaggio sono strettamente riservate ed esclusivamente
indirizzate al destinatario indicato (oppure alla persona responsabile di
rimetterlo al destinatario). Vogliate tener presente che qualsiasi uso,
riproduzione o divulgazione di questo messaggio è vietato. Nel caso in cui
aveste ricevuto questo messaggio per errore, vogliate cortesemente
avvertire il mittente e distruggere il presente messaggio.
According to Italian law D.Lgs. 196/2003 concerning privacy, if you are not
the addressee (or responsible for delivery of the message to such person)
you are hereby notified that any disclosure, reproduction, distribution or
other dissemination or use of this communication is strictly prohibited

-- 
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