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

At 20:07 29/11/2014 +0100, Luuk Noname wrote:
> On 29-11-2014 16:28, Carlo Strata wrote:
> > I recently deal with a supplier catalog/price list spreadsheet xlsx 
> > file. That file use the "LOOKUP()" function (in Italy "RICERCA()") 
> > in many places. In one of those occurrences, the first LOOKUP() 
> > parameter (Search Criterion) was missed, but on Microsoft Excel 
> > this was ok (no errors in the cell), in LibreOffice was ko (Err:511, missing
> > variable/parameter)! I think this difference was yielded by 
> > different assumed values of the missing parameter and/or different 
> > validation rules. So compliance depends not only on file format, 
> > but also on function behaviour/validation on different program.
>
> I do not see a difference, besides a language difference (i have 
> Dutch version of Excel, en LO in English) (in Excel is see '#N/B', 
> when LOOKUP did not found, in LO is see '#N/A')
>
> I uploaded my testfile here:
> http://wikisend.com/download/402228/zoeken.xlsx

I don't think the questioner is referring to the situation in your 
example, where the cell referred to by the first parameter is empty, 
but that where the LOOKUP() reference itself contains no first 
parameter - in other words, where its opening parenthesis is followed 
immediately by the separator character. In that case, the behaviour 
does appear to be different: LibreOffice treats it as faulty formula, 
whereas Microsoft Excel evaluates the (slightly deficient) formula 
and returns #N/A.

Brian Barker 


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