Indirect function result in #REF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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() 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.
 
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
 
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.
 
Thanks for the insightful explanation!

Jules

Dave Peterson said:
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.
Click to expand...
 
Back
Top