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

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

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

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

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

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

indirect function
 

Use this where a1 is the row and column(i:i) is the column. You can change
absolutes and starting area to suit.

INDIRECT($O11&"!"&ADDRESS(ROW($A1),COLUMN(I:I)))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
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