Talk:Calc/Performance/VLOOKUP

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)