Combining formula and cell reference

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!!!

=INDIRECT("Worksheetname!F"&BIGLONGFORMLA&":T500")

HTH
--
AP

"Drew" <[email protected]> a écrit dans le message de news:
[email protected]...
> 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!!!

Look at the INDIRECT() function

--
Kind regards,

Niek Otten

"Drew" <[email protected]> wrote in message news:[email protected]...
| 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!!!

THANK YOU FROM THE BOTTOM OF MY HEART

"Ardus Petus" wrote:

> =INDIRECT("Worksheetname!F"&BIGLONGFORMLA&":T500")
>
> HTH
> --
> AP
>
> "Drew" <[email protected]> a écrit dans le message de news:
> [email protected]...
> > 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!!!
>
>
>