[AirgasRob]

Is it possible to use INDIRECT in a OFFSET formula?

Here is the formula =OFFSET(Sheet1!$B$29,,ROWS($1:1)-1)

I would like to replace $B$29 with =INDIRECT($F$1)

[David Biddulph[_2_]]

In which case =OFFSET(INDIRECT("Sheet1!"&$F$1),,ROWS($1:1)-1)
--
David Biddulph

"AirgasRob" wrote in message
...
Is it possible to use INDIRECT in a OFFSET formula?

Here is the formula =OFFSET(Sheet1!$B$29,,ROWS($1:1)-1)

I would like to replace $B$29 with =INDIRECT($F$1)