| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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() |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Alternative to IF | Excel Worksheet Functions | |||
| If alternative | Excel Worksheet Functions | |||
| Alternative to Indirect | Excel Worksheet Functions | |||
| alternative to VLOOKUP | Excel Worksheet Functions | |||
Hybrid Mode
