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.
Max Aboutproperty wrote:
Hi Anthony,
Further to my earlier email.
=LOOKUP(1;M12:M791;C12:C791)
The search for "1" is a product of then IF statement
=IF($I$8>H14;1;0)
=IF($I$8>H15;1;0)
=IF($I$8>H16;1;0) Etc
Therefore I end up searching a column which has 0's until the IF
statement is true (1).
Then the column changes to 1's.
Earlier versions would search for the first 1 (one) in the column.
Version 2 searches for the last 1 (one) in the column.
My question now will be :
_How many of the other Calc functions have been changed ?_
I depend on these spreadsheets for legal documents !
Can I trust my spreadsheets in a court of law ?
Or do I need to proof check every spreadsheet generated with earlier
versions of OpenOffice Calc ?
I have solved the problem of missing / corrupt Calc help files (thanks
to the forums out there).
Would have thought that this little problem would have be resolved very
quickly.
Cheers,
Max.
Anthony Chilco wrote:
Hi Max,
A little more information would go a long way to getting you the help
you need. Tell us what your operating system is and give some examples
of the formulae that don't work and the results that you are getting.
tc
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.
Max Aboutproperty wrote:
I have used ver 1.1.0
Created spreadsheets using "lookup" and "if".
I installed ver 2.0 30 minutes ago.
My spreadsheets do not work.
Have re-installed ver 2.0
No joy.
Cheers,
Max.
------------------------------------------------------------------------
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.23/240 - Release Date: 25/01/2006
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
