incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <b.m.bar...@btinternet.com>
Subject Re: Bug
Date Thu, 14 Jun 2012 21:42:13 GMT
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


Mime
View raw message