Cell Address reference

[M.Farook]

Hi.

Any function available to get value of a cell using the
cell value from another cell?

Example:

Value at A1 = 'abc'
Value at A5 = 'A1' (which is cell address of 'abc')

At A6 i should get value of A1 using A5 (which is refering
A1)

Hope i get a solution

Thanks in advance.

Mohamed Farook

 

[Max]

You have:

in A1: abc
in A5: A1

Put in A6: =INDIRECT(A5)

A6 returns "abc"

 

[Guest]

Thanks Max.

It opened a new window for me.

Mohd

 

[Max]

You're welcome, Mohd !
Thanks for the feedback.