Cell Address Value

[Mohamed Farook]

Hi

How can I display the value of a cell which is cell
address of another cell having value 'abc'?

Example : Content of A1 = 'abc'
Content of A2 = 'A1' which is cell address
of 'abc'

I need to get value of 'abc' using value of A2.

Hope i get a solution.

Thanks in advance.

Mohamed farook

 

[Bob Phillips]

=INDIRECT(A2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Norman Harker]

Hi Mohamed!

Use the INDIRECT function.
Returns a reference indicated by a value provided as text. Volatile
function.

From your description:

=INDIRECT(A2)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[JMay]

Keep in mind that the Indirect() function is an absolute address - meaning
if you were to "move" your cell A1 somewhere else your A2 will no longer
return the previous value.

 

[Peo Sjoblom]

Actually it is the hard coded content of A2 that makes it that way,

=INDIRECT(A2)

is not hard coded by itself since if you insert a row at the top it will
change to

=INDIRECT(A3)

 

[Flamikey]

You make the INDIRECT function relative if you combine it with the
Cell(address) function

 

[Peo Sjoblom]

I don't see what that has to do with my post? Or are you saying that this is
absolute

=INDIRECT(A2)

 

[Guest]

Thank you friends...

Its working...

Mohd

-----Original Message-----
Hi Mohamed!

Use the INDIRECT function.
Returns a reference indicated by a value provided as text. Volatile
function.

From your description:

=INDIRECT(A2)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.