Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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


Check out our Excel Resources

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

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

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

or simply

=address(a1,2)

Aladin


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

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

Thank you for the fast reply!

David


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

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


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

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?


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.