Use reference text from one cell in another function call

R

Randy

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.
 
R

Ron Coderre

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)
 
D

Dave Peterson

Maybe...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top