ExcelBanter - Indirect alternatives

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

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

- - Indirect alternatives (https://www.excelbanter.com/excel-discussion-misc-queries/220356-indirect-alternatives.html)

Brad

Indirect alternatives

Using XL 2007 with 2003 compatibility

The below equation works - but are there better alternatives

=INDIRECT(Model_info!$E$25&"!R"&ROW()&"C"&COLUMN() ,FALSE)

Roger Govier[_3_]

Indirect alternatives

Hi Brad

If in Model_info!E25 you enter something like Sheet3!$!:$65536, rather than
just a sheet name, then you can use

=INDEX(INDIRECT(Sheet2!$E$30),ROW(),COLUMN())

--
Regards
Roger Govier

"Brad" wrote in message
...
Using XL 2007 with 2003 compatibility

The below equation works - but are there better alternatives

=INDIRECT(Model_info!$E$25&"!R"&ROW()&"C"&COLUMN() ,FALSE)

All times are GMT +1. The time now is 09:07 AM.