Hi Frank,
(An old one - I've some more ;-) )
Cor Nouws wrote (18-10-2007 11:38)
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,
Easy to fix as you suggested. Only saving as xls and re-opening, again
shows #NA ...
Saving as ods does save the results.
Regards,
Cor
--
"The Year of 3" -2008- "Het jaar van 3"
Cor Nouws
Arnhem - Netherlands - nl.OpenOffice.org - marketing contact
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
