| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
indirect function
I have the following formula which is giving me the #REF! error. If I make the last reference a label it works but by making it a real reference the formula dies. What am I doing wrong. Thanks =INDIRECT("'"&$a8&"'"!"&D$89) doesn't work =INDIRECT("'"&$a8&"'"!"&"D$89") works but now I can't copy the formula to use relative addresses. =indirect(("'"&$a8&"'"!" this part works and is referencing a sheet within a work &D$89 this part does not. I am trying to reference a cell location in the referenced sheet ) I want to be able to copy the formula to give me the relative reference in the other sheet. -- Tom |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
indirect function
Perhaps something like:
=INDIRECT("'" & $A8 & "'!" & "D$" & ROWS($A$1:A1)+88) This can be copied downward -- Gary''s Student - gsnu200818 "Thomas Roos" wrote: I have the following formula which is giving me the #REF! error. If I make the last reference a label it works but by making it a real reference the formula dies. What am I doing wrong. Thanks =INDIRECT("'"&$a8&"'"!"&D$89) doesn't work =INDIRECT("'"&$a8&"'"!"&"D$89") works but now I can't copy the formula to use relative addresses. =indirect(("'"&$a8&"'"!" this part works and is referencing a sheet within a work &D$89 this part does not. I am trying to reference a cell location in the referenced sheet ) I want to be able to copy the formula to give me the relative reference in the other sheet. -- Tom |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
indirect function
I want to be able to copy to the right.
What would be the answer? Thanks -- Tom "Gary''s Student" wrote: Perhaps something like: =INDIRECT("'" & $A8 & "'!" & "D$" & ROWS($A$1:A1)+88) This can be copied downward -- Gary''s Student - gsnu200818 "Thomas Roos" wrote: I have the following formula which is giving me the #REF! error. If I make the last reference a label it works but by making it a real reference the formula dies. What am I doing wrong. Thanks =INDIRECT("'"&$a8&"'"!"&D$89) doesn't work =INDIRECT("'"&$a8&"'"!"&"D$89") works but now I can't copy the formula to use relative addresses. =indirect(("'"&$a8&"'"!" this part works and is referencing a sheet within a work &D$89 this part does not. I am trying to reference a cell location in the referenced sheet ) I want to be able to copy the formula to give me the relative reference in the other sheet. -- Tom |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
indirect function
try
=INDIRECT($a8&"!$h1") -- Don Guillett Microsoft MVP Excel SalesAid Software "Thomas Roos" wrote in message ... I have the following formula which is giving me the #REF! error. If I make the last reference a label it works but by making it a real reference the formula dies. What am I doing wrong. Thanks =INDIRECT("'"&$a8&"'"!"&D$89) doesn't work =INDIRECT("'"&$a8&"'"!"&"D$89") works but now I can't copy the formula to use relative addresses. =indirect(("'"&$a8&"'"!" this part works and is referencing a sheet within a work &D$89 this part does not. I am trying to reference a cell location in the referenced sheet ) I want to be able to copy the formula to give me the relative reference in the other sheet. -- Tom |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
indirect function
It won't copy as relative value to the right. Any other ideas?
-- Tom "Don Guillett" wrote: try =INDIRECT($a8&"!$h1") -- Don Guillett Microsoft MVP Excel SalesAid Software "Thomas Roos" wrote in message ... I have the following formula which is giving me the #REF! error. If I make the last reference a label it works but by making it a real reference the formula dies. What am I doing wrong. Thanks =INDIRECT("'"&$a8&"'"!"&D$89) doesn't work =INDIRECT("'"&$a8&"'"!"&"D$89") works but now I can't copy the formula to use relative addresses. =indirect(("'"&$a8&"'"!" this part works and is referencing a sheet within a work &D$89 this part does not. I am trying to reference a cell location in the referenced sheet ) I want to be able to copy the formula to give me the relative reference in the other sheet. -- Tom |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
indirect function
try this
=INDIRECT(""&$A8&"!"&D$89) On Dec 8, 12:38*am, Thomas Roos wrote: I have the following formula which is giving me the #REF! error. If I make the last reference a label it works but by making it a real reference the formula dies. *What am I doing wrong. Thanks =INDIRECT("'"&$a8&"'"!"&D$89) doesn't work =INDIRECT("'"&$a8&"'"!"&"D$89") works but now I can't copy the formula to use relative addresses. =indirect(("'"&$a8&"'"!" * this part works and is referencing a sheet within a work &D$89 this part does not. I am trying to reference a cell location in the referenced sheet ) I want to be able to copy the formula to give me the relative reference in the other sheet. -- Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect function | Excel Discussion (Misc queries) | |||
| INDIRECT function inside AND function | Excel Worksheet Functions | |||
| Indirect function ? | Excel Worksheet Functions | |||
| INDIRECT Function | Links and Linking in Excel | |||
| Indirect Function and Sum | Excel Worksheet Functions | |||
Hybrid Mode
