Hi Cor, On Thursday, 2007-10-18 11:38:21 +0200, Cor Nouws wrote:
> Frank Stecher wrote (18-10-2007 10:03) > > >The problem is the unsorted search vector used with the VLOOKUP > >functions in column H. Excel requires a sorted search vector for the > >vlookup as used in the column as well as Calc do. At least they require > >this in the help for the function. So they break the own rules. They probably don't break the rule, but for unsorted data the so-called sorted range lookup may deliver any result that fits for a less-or-equal query. The actual result delivered depends on the algorithm used. It is coincidence that Calc for that data constellation delivers #N/A. So whoever used the data for vital tasks in Excel or some viewer should carefully check the results it delivered with reality ;-) Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks.
pgp9cygRQqQKk.pgp
Description: PGP signature
