ExcelBanter - OFFSET and INDIRECT

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - OFFSET and INDIRECT (https://www.excelbanter.com/excel-discussion-misc-queries/191424-offset-indirect.html)

AirgasRob

OFFSET and INDIRECT

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_]

OFFSET and INDIRECT

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)

All times are GMT +1. The time now is 08:14 PM.