Use reference text from one cell in another function call
 

I want to be able to use a range reference of cells as text in one cell by a
function in another cell. I can create the range using CONCATENATE (e.g.,
A310:A320) which will appear as text in a cell, but I can't seem to use this
in another function call. Does anyone know how to use this range of cells
listed as text in one cell in a separate function call?

I've tried using CONCATENATE within the function and also with & symbols but
the function won't work.

The following doesn't work and replacing the range specifications with
CONCATENATE equivalents doesn't seem to work.

= FORECAST(50,"A"&B18&":A"&B19,"B"&B18&":B"&B19)

B18 and B19 have the proper numbers for the row and columns.

Use reference text from one cell in another function call
 

Try this:

=FORECAST(50,INDIRECT("A"&B18&":A"&B19),INDIRECT(" B"&B18&":B"&B19))

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Randy" wrote in message
...
I want to be able to use a range reference of cells as text in one cell by
a
function in another cell. I can create the range using CONCATENATE (e.g.,
A310:A320) which will appear as text in a cell, but I can't seem to use
this
in another function call. Does anyone know how to use this range of cells
listed as text in one cell in a separate function call?

I've tried using CONCATENATE within the function and also with & symbols
but
the function won't work.

The following doesn't work and replacing the range specifications with
CONCATENATE equivalents doesn't seem to work.

= FORECAST(50,"A"&B18&":A"&B19,"B"&B18&":B"&B19)

B18 and B19 have the proper numbers for the row and columns.

Use reference text from one cell in another function call
 

Maybe...

= FORECAST(50,indirect("A"&B18&":A"&B19),indirect("B "&B18&":B"&B19))



Randy wrote:

I want to be able to use a range reference of cells as text in one cell by a
function in another cell. I can create the range using CONCATENATE (e.g.,
A310:A320) which will appear as text in a cell, but I can't seem to use this
in another function call. Does anyone know how to use this range of cells
listed as text in one cell in a separate function call?

I've tried using CONCATENATE within the function and also with & symbols but
the function won't work.

The following doesn't work and replacing the range specifications with
CONCATENATE equivalents doesn't seem to work.

= FORECAST(50,"A"&B18&":A"&B19,"B"&B18&":B"&B19)

B18 and B19 have the proper numbers for the row and columns.

--

Dave Peterson

Use reference text from one cell in another function call
 

Thought I had tried that already, but apparently not. Worked well. Thanks!

"Dave Peterson" wrote:

Maybe...

= FORECAST(50,indirect("A"&B18&":A"&B19),indirect("B "&B18&":B"&B19))



Randy wrote:

I want to be able to use a range reference of cells as text in one cell by a
function in another cell. I can create the range using CONCATENATE (e.g.,
A310:A320) which will appear as text in a cell, but I can't seem to use this
in another function call. Does anyone know how to use this range of cells
listed as text in one cell in a separate function call?

I've tried using CONCATENATE within the function and also with & symbols but
the function won't work.

The following doesn't work and replacing the range specifications with
CONCATENATE equivalents doesn't seem to work.

= FORECAST(50,"A"&B18&":A"&B19,"B"&B18&":B"&B19)

B18 and B19 have the proper numbers for the row and columns.

--

Dave Peterson