Indirect function result in #REF
 

Hi,

I tried to use the indirect function (i.e. indirect(A3)) where A3 contains a
number (say 3), but the result came back as #REF. Any idea what caused the
problem.

Thanks,
Jules

Indirect function result in #REF
 

Try it as: =INDIRECT("A3")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Julie L" wrote:
Hi,

I tried to use the indirect function (i.e. indirect(A3)) where A3 contains a
number (say 3), but the result came back as #REF. Any idea what caused the
problem.

Thanks,
Jules

Indirect function result in #REF
 

=Indirect() expects something that looks like a range address/range name in that
cell.

So if A3 contained X99, then
=indirect(a3)
would return the value contained in X99.



Julie L wrote:

Hi,

I tried to use the indirect function (i.e. indirect(A3)) where A3 contains a
number (say 3), but the result came back as #REF. Any idea what caused the
problem.

Thanks,
Jules

--

Dave Peterson

Indirect function result in #REF
 

Thank you Dave, I now understand what created the problem. Reference in
indirect should refer to an address, therefore, if a3 contains 3, the result
would be too volatile since excel is trying to pick up all information from
row 3.

Thanks for the info!

Jules

"Dave Peterson" wrote:

=Indirect() expects something that looks like a range address/range name in that
cell.

So if A3 contained X99, then
=indirect(a3)
would return the value contained in X99.



Julie L wrote:

Hi,

I tried to use the indirect function (i.e. indirect(A3)) where A3 contains a
number (say 3), but the result came back as #REF. Any idea what caused the
problem.

Thanks,
Jules

--

Dave Peterson

Indirect function result in #REF
 

And "3" isn't a valid range address, either.

But if you had '3:3 (make sure it's text and not a time!) in A1, then you could
use:

=sum(indirect(a1))
to add up all the values in row 3.


Julie L wrote:

Thank you Dave, I now understand what created the problem. Reference in
indirect should refer to an address, therefore, if a3 contains 3, the result
would be too volatile since excel is trying to pick up all information from
row 3.

Thanks for the info!

Jules

"Dave Peterson" wrote:

=Indirect() expects something that looks like a range address/range name in that
cell.

So if A3 contained X99, then
=indirect(a3)
would return the value contained in X99.



Julie L wrote:

Hi,

I tried to use the indirect function (i.e. indirect(A3)) where A3 contains a
number (say 3), but the result came back as #REF. Any idea what caused the
problem.

Thanks,
Jules

--

Dave Peterson


--

Dave Peterson

Indirect function result in #REF
 

Thanks for the insightful explanation!

Jules

"Dave Peterson" wrote:

And "3" isn't a valid range address, either.

But if you had '3:3 (make sure it's text and not a time!) in A1, then you could
use:

=sum(indirect(a1))
to add up all the values in row 3.


Julie L wrote:

Thank you Dave, I now understand what created the problem. Reference in
indirect should refer to an address, therefore, if a3 contains 3, the result
would be too volatile since excel is trying to pick up all information from
row 3.

Thanks for the info!

Jules

"Dave Peterson" wrote:

=Indirect() expects something that looks like a range address/range name in that
cell.

So if A3 contained X99, then
=indirect(a3)
would return the value contained in X99.



Julie L wrote:

Hi,

I tried to use the indirect function (i.e. indirect(A3)) where A3 contains a
number (say 3), but the result came back as #REF. Any idea what caused the
problem.

Thanks,
Jules

--

Dave Peterson


--

Dave Peterson

Indirect function result in #REF
 

Thanks for the information Max!

"Max" wrote:

Try it as: =INDIRECT("A3")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Julie L" wrote:
Hi,

I tried to use the indirect function (i.e. indirect(A3)) where A3 contains a
number (say 3), but the result came back as #REF. Any idea what caused the
problem.

Thanks,
Jules

Indirect function result in #REF
 

welcome, Julie. Thanks for the liner
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Julie L" wrote in message
...
Thanks for the information Max!