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 ?
The search vector for LOOKUP has to be sorted. This was a documented
requirement already in older versions. If you want to search for the
first exact match in an unsorted list, use MATCH with type 0 (and INDEX
to return the corresponding entry from another list).
See issue 2168 for the details how LOOKUP was changed.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
