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

Hi Everyone,

Brian understood exactly what I meant. I.e.:
=LOOKUP(;A5)

Have a nice sunday,

Carlo

--
ing. Carlo Strata
-
via Botticelli 1/4
30031 Dolo - VE
Italia - Italy
-
tel. +39.041.822.0665
cell. +39.347.85.69.824
Skype carlo.strata
Google carlo.strata.69
-
carlo.strata@tiscali.it
PEC: carlo.strata@ingpec.eu

Il 30/11/2014 11:48, Brian Barker ha scritto:
> 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