Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

Hi,

Am 30.11.2014 um 23:37 schrieb Carlo Strata:
> ... so this is an Excel problem because it behaves differently with
> respect to its own help...?!!!

Not really.

Excel states, that you must apply the first parameter and you must
not leave it empty. (It´s required.) If you follow this, everything
is fine. And it´s the same thing in LibreOffice.

There is no specification for the behaviour of the function, in case
it´s not used according to the rules.

You can expect Excel and LibreOffice behave the same, if you use
functions according to their definition and the instructions given
in the documentation. You cannot expect identical behaviour, in case
you violate the instructions.

--> Your Problem is not an Excel problem neither a LibreOffice
problem, it´s a users problem. ;-)

Cheers,
Stefan



-- 
LibreOffice - Die Freiheit nehm' ich mir!

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