Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 16 Feb 2016 20:48:51 +0100How to extend a formula using INDIRECT ?https://ask.libreoffice.org/en/question/64563/how-to-extend-a-formula-using-indirect/ I want to reference a column from another sheet, with the other sheet name configurable, so I use this formula:
=INDIRECT($K2 & ".C2")
with:
* K2 the cell containing the other sheet name
* C the column from the other sheet
How to extend the formula to the whole column?
Since "C2" is a string, calc takes "K" as the variable and not "C"...Tue, 16 Feb 2016 20:48:51 +0100https://ask.libreoffice.org/en/question/64563/how-to-extend-a-formula-using-indirect/