Joe Smith wrote:
In section 6.13.7, "LOOKUP", p.246, shows this test case:
> =LOOKUP(6.1;[.B51:.B57];[.C51:.C57])
> 11
> 2
> Lookup – if not exact, largest available that is smaller than value
to Find
I believe the correct result there is 19, not 11. DEV300_m5 gives 19.
Did you enter the formula in a locale where 6.1 is parsed as a date
(with a value larger than those from the lookup list)?
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
