Indirect alternatives

B

Brad

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indirect alternatives 0
Indirect alternatives 0
Indirect Alternatives 2
Indirect alternatives 1
Indirect alternative 2
Indirect alternatives 1
Using the INDIRECT function across multiple worksheets 0
MIN across worksheets, with INDIRECT 2

Top