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: [email protected] For additional commands, e-mail: [email protected]
