[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 : > You will

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

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.

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 : > Am 23.11.2015 um 16:33 schrieb Michele contabilmenteAG: > > Anomaly discovered in