https://bugs.documentfoundation.org/show_bug.cgi?id=167134
--- Comment #2 from Regina Henschel <[email protected]> --- (In reply to m_a_riosv from comment #1) > Created attachment 201384 [details] > Modified sample file > > Sorry @Regina but seems Zeile7={11;12;13;14;15;16;17} is a vertical vector, > changing it to horizontal produce for me the same results as without named > ranges. > > Maybe I'm wrong, but results in red are an 'Index is outside result vector' > searching a vertical range in an inner horizontal range. The LOOKUP function has to work independent of the direction of the result vector. That is, when the search vector is vertical, LOOKUP has to calculate the same result for a vertical result vector as for a horizontal result vector. That works for the case the constant array for the result vector is not given directly but via a named range. It also works if you do not use a constant array but a reference to a cell range. Only in the case, that the constant array is directly given in the formula, it does not work. -- You are receiving this mail because: You are the assignee for the bug.
