Use reference text from one cell in another function call

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Randy - 10 Mar 2008 18:13 GMT

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.

Reply to this Message

Ron Coderre - 10 Mar 2008 18:22 GMT

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)

>I want to be able to use a range reference of cells as text in one cell by
>a
[quoted text clipped - 14 lines]
>
> B18 and B19 have the proper numbers for the row and columns.

Reply to this Message

Dave Peterson - 10 Mar 2008 18:22 GMT

Maybe...

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

> 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.,
[quoted text clipped - 11 lines]
>
> B18 and B19 have the proper numbers for the row and columns.

Signature

Dave Peterson

Reply to this Message

Randy - 10 Mar 2008 18:31 GMT

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

> Maybe...
>
[quoted text clipped - 15 lines]
> >
> > B18 and B19 have the proper numbers for the row and columns.

Reply to this Message