https://bugs.documentfoundation.org/show_bug.cgi?id=158393
--- Comment #3 from ady <[email protected]> --- (In reply to ady from comment #2) > (In reply to Fergus from comment #0) > > > --(RANGE=CELL) * is a more capable Vlookup method used in intermediary > > skill spreadsheets. > > It could be helpful to add (in your next comment) some link to some web page > with an example or explanation of how this formula/syntax is expected to > work (in whichever site/forum). > > As per the specific example presented in comment 0, does that work in MS > Excel or in any other spreadsheet tool or in some older version of Calc? Just to be clear, I agree with comment 1, unless proven differently, and that's the reason for my questions. FWIW, if the syntax is used as in the SUMPRODUCT() function, please be aware that SUMPRODUCT() acts as an array function without requiring its introduction as an array formula with Ctrl+Shift+Enter. Having said that, I would be happy to get a different usage/example, or a clearer explanation of what should be the formulas in cells A2 and A3 and their expected results. -- You are receiving this mail because: You are the assignee for the bug.
