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”…