MrExcel Publishing
Your One Stop for Excel Tips & Solutions

A1 = "3" :: B("A1") = B3


Posted by David Megnin on June 21, 2001 3:12 PM

Is it possible to use the value of a cell as the row reference of another cell?

e.g. cell A1 contains the value "3",
in cell C1 I want a formula like B("A1")to equal "B3"
so that if the value in A1 changes to "5" then C1 would
equal "B5".

I've experimented with different syntaxes with no succes. B"A1", B(A1), B("A1") all resulted in errors.

Thanks in advance,
david


Posted by Aladin Akyurek on June 21, 2001 3:15 PM

=address(a1,column(B:B))

or simply

=address(a1,2)

Aladin

Posted by David Megnin on June 21, 2001 3:32 PM

Aladin,

Thank you for the fast reply!

David

Posted by Natali on June 21, 2001 4:00 PM

Hi David
i tried to understand your explantaion but i did not manage to . could you please the fromula.You can email me at afrench_lady@yahoo.com
many thanks.
Natali

Posted by natli on June 21, 2001 4:03 PM

:Hi David
i tried to understand your explantaion but i did not manage to . could you please the fromula.You can email me at afrench_lady@yahoo.com
many thanks.
Natali Is it possible to use the value of a cell as the row reference of another cell?