Indirect alternative
 

Using Excel 2007 (with compatibility with 2003)

Currently using the following function (a multitude of times)

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

Where Model_info!$E$25 - will be different sheet names.

What alternatives do I have?

Indirect alternative
 

On Feb 11, 1:11*am, Brad wrote:
Using Excel 2007 (with compatibility with 2003)

Currently using the following function (a multitude of times)

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

Where Model_info!$E$25 - will be different sheet names.

What alternatives do I have?

Indirect function has two variables, first one is reference text in
your case Model_info!$E$25
and second one is a logical value (true, false).
What is the &"!R"&ROW()&"C"&COLUMN() phrase in your command?
If you want to concatenate, you have to use
INDIRECT(Model_info!$E$25,FALSE)&"!R"&ROW()&"C"&CO LUMN()

Indirect alternative
 

Hi,

Why don't you tell us what it is you want your formula to do. And why the
current formula does not meet your needs?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Brad" wrote:

Using Excel 2007 (with compatibility with 2003)

Currently using the following function (a multitude of times)

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

Where Model_info!$E$25 - will be different sheet names.

What alternatives do I have?