Ask Your Question

Revision history [back]

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