Address

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

In cell A1 I have the value "=A2"
I want a formula that will look at A1, and then return the value i
A2.

Do I use INDIRECT and how
 
Hi

If you have the = sign in the cell as well (so that the cell displays
=A2 ), you could use
=INDRECT(MID(A1,2,2))

Andy.
 
Hi
try
=INDIRECT(A1)
but change the content of A1 to simply 'A2' (without apostrophes and
equation sign)
 
=INDIRECT("A1")
works for me when
=A2
is entered in A1.

Are you sure that you used the quotes?
Leaving out the quotes *does* return a #REF! error.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I get #REF!
 
Hi
=INDIRECT("A1")
will always return the value from A1. So it's the same as
=A1

you probably meant
=INDIRECT(A1)
for this the equation sign in A1 has to be removed
 
Yes Frank, I realize that!

My reply was to the OP,
who stated that a #REF! error was returned when:
=INDIRECT("A1")
was used,
Which is not correct.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------



Hi
=INDIRECT("A1")
will always return the value from A1. So it's the same as
=A1

you probably meant
=INDIRECT(A1)
for this the equation sign in A1 has to be removed
 
Back
Top