ExcelBanter - Indirect alternatives

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Indirect alternatives (https://www.excelbanter.com/excel-worksheet-functions/220640-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)
There are several sheets that are date driven, that the format is the same
but the numbers on the sheets are different. The "assumptions" sheet then is
used to run the model. The date entered by the user will determine which
sheet to grab the values from.

Fred Smith[_4_]

Indirect alternatives

Do you have a question?

Regards,
Fred.

"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)
There are several sheets that are date driven, that the format is the same
but the numbers on the sheets are different. The "assumptions" sheet then
is
used to run the model. The date entered by the user will determine which
sheet to grab the values from.

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