Cell Address Value

  • Thread starter Thread starter Mohamed Farook
  • Start date Start date
M

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
 
=INDIRECT(A2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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.
 
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.
 
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)
 
You make the INDIRECT function relative if you combine it with the
Cell(address) function
 
I don't see what that has to do with my post? Or are you saying that this is
absolute

=INDIRECT(A2)
 
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.



.
Click to expand...
 
Back
Top