Hi Anthony,
I have resolved the problem by altering my IF statement.
As you say, it worked in ver 1, must have been a bug, thus gave me a
false sense of security.
Thank you and your colleagues for taking the time.
I have been a user of OpenOffice for years, before that StarOffice.
Keep up the great work !
Cheers,
Max.
Anthony Chilco wrote:
Hi Max,
I don't have v1 installed any more, but I tried a similar search and
get the same results that you do. I saved the file as xls and opened
it in Excel97 and get the same result there as well. From the Excel
help, I get the impression that lookup is intended to search a list of
unique values in ascending order. Whenever there are consecutive
identical values, or a correct 'hit' followed by lower values with a
subsequent match, it will always find the last match. If what you're
doing worked in version 1, that must have been a bug. If there was a
change made, it will be documented somewhere on the openoffice.org
site. I can't tell you where, but someone else on the list should know.
tc
p.s. This will work:
=OFFSET(C12;MATCH(1;M12:M791,0)-1;0)
You appear not to be subscribed to the users mailing list. You could
miss many of the replies to your post unless you do subscribe. Just
send a blank message addressed to <[EMAIL PROTECTED]>
using the e-mail account through which you want to receive it. You
will receive a message asking you to confirm your subscription by
replying to it. See http://support.openoffice.org/index.html for more
options.
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.23/242 - Release Date: 26/01/2006
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
