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