How to extend a formula using INDIRECT ?

asked 2016-02-16 20:48:51 +0100

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"...

edit retag flag offensive close merge delete