Combining formula and cell reference

D

Drew

Is there any way to combine a formula as part of the cell reference?
For example I want to use this type of format, but it doesn't work:

=Worksheetname!ADDRESS(BIG LONG FORMULA,6):T500

the output I want is: Worksheetname!F#:T500

# is defined by the BIG LONG FORMULA

If anyone knows the proper syntax, I would greatly appreciate it!!!
 
N

Niek Otten

Look at the INDIRECT() function

--
Kind regards,

Niek Otten

| Is there any way to combine a formula as part of the cell reference?
| For example I want to use this type of format, but it doesn't work:
|
| =Worksheetname!ADDRESS(BIG LONG FORMULA,6):T500
|
| the output I want is: Worksheetname!F#:T500
|
| # is defined by the BIG LONG FORMULA
|
| If anyone knows the proper syntax, I would greatly appreciate it!!!
 
Top