Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to call a reference to a cell in external file | Excel Worksheet Functions | |||
How do i call a function to a cell? | Excel Worksheet Functions | |||
Reference Call | Excel Discussion (Misc queries) | |||
Reference Call | Excel Discussion (Misc queries) | |||
Reference Call | Excel Discussion (Misc queries) |