Hi Frank,
Frank Stecher wrote (18-10-2007 10:03)
the problem is not the missing linked file, at least not with OOo2.3.
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.
The problem can be solved either by sorting the search vector or setting
the parameter (zero or false) for unsorted search vectors in the vlookup
formula.
Thanks! See that I get it working,
--
Cor Nouws
Arnhem - Netherlands
nl.OpenOffice.org - marketing contact
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
