You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Dorothea Br�cksken <br...@arcor.de> on 2012/06/14 22:40:42 UTC
Bug
Hallo OOO-Team,
habe Fehler in Version 3.4 gefunden.
Funktion "VERWEIS()" funktioniert nicht wie aus fr�heren Versionen gewohnt.
siehe Anhang
Mit freundlichen Gr��en
Tino Br�cksken
Re: Bug
Posted by Brian Barker <b....@btinternet.com>.
At 22:40 14/06/2012 +0200, Dorothea "Tino" Brücksken wrote:
>habe Fehler in Version 3.4 gefunden.
>Funktion "VERWEIS()" funktioniert nicht wie aus früheren Versionen gewohnt.
>siehe Anhang
According to the help text for the LOOKUP()
function, "... the search vector for the LOOKUP
must be sorted ascending, otherwise the search
will not return any usable results." Your search
vector (4, 3, 1, 2) is not sorted in ascending
order, which explains the problem. If you sort
the data table B5:D8 by column D ascending, your
formulae work as you would expect.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org