Talk:Calc/Performance/VLOOKUP
From Apache OpenOffice Wiki
ARRAY as 3rd Parameter
Could the VLOOKUP() function be extended / overloaded to accept an array as 3rd parameter? Something like:
VLOOKUP(A2, _range_, ARRAY(_some_array_), BOOL) # where _some_array_ contains the positions (aka columns) that we wish # to retrive from the range _range_ # e.g. ARRAY(2,3,6) => retrive columns C0 + 2, C0 + 3 and C0 + 6 # where C0 = first column in _range_
The retrieved values should be inserted into the same row as the VLOOKUP(), starting with the current cell and extending for length(ARRAY(_some_array_))
This way, there is NO need for:
- duplicate operations
- complex cache
- operation could be completed in one pass
Discoleo 22:56, 18 July 2007 (CEST)