| 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!!! |
| 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 | |||
Threaded Mode
