| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining formula and cell reference
=INDIRECT("Worksheetname!F"&BIGLONGFORMLA&":T500")
HTH -- AP "Drew" a écrit dans le message de news: ... 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!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining formula and cell reference
Look at the INDIRECT() function
-- Kind regards, Niek Otten "Drew" wrote in message ... | 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!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining formula and cell reference
THANK YOU FROM THE BOTTOM OF MY HEART
"Ardus Petus" wrote: =INDIRECT("Worksheetname!F"&BIGLONGFORMLA&":T500") HTH -- AP "Drew" a écrit dans le message de news: ... 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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to paste formula but reference a fixed cell | Excel Discussion (Misc queries) | |||
| Function/ formula to output a cell reference | Excel Worksheet Functions | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
