using text as a cell ref
 

Hi all,

How can I use A1 = 1 and A2 = 2
then combine them so in A3 I have the contents of cell Row 1, column 2?

Your help would be much appreciated... CC

Hi,

Try one of these:

=INDEX(1:65536,A1,A2)
=INDIRECT(ADDRESS(A1,A2))

Regards,
KL


"CC-Khriz" wrote in message
...
Hi all,

How can I use A1 = 1 and A2 = 2
then combine them so in A3 I have the contents of cell Row 1, column 2?

Your help would be much appreciated... CC

Thanks ,
that just what I needed.
BR CC

"KL" wrote:

Hi,

Try one of these:

=INDEX(1:65536,A1,A2)
=INDIRECT(ADDRESS(A1,A2))

Regards,
KL


"CC-Khriz" wrote in message
...
Hi all,

How can I use A1 = 1 and A2 = 2
then combine them so in A3 I have the contents of cell Row 1, column 2?

Your help would be much appreciated... CC

On Mon, 5 Sep 2005 06:33:03 -0700, "CC-Khriz"
wrote:

Hi all,

How can I use A1 = 1 and A2 = 2
then combine them so in A3 I have the contents of cell Row 1, column 2?

Your help would be much appreciated... CC

I'm interpreting this to mean that you have acvalue in cell B1 (Row 1
from A1, and Column B from A2), which you want returned in A3.

In which case the formula is

=INDIRECT(ADDRESS(A1,A2))


HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

"KL" wrote...
Try one of these:

=INDEX(1:65536,A1,A2)
=INDIRECT(ADDRESS(A1,A2))
....

The former is a MUCH BETTER idea than the latter since INDEX isn't usually
volatile, but INDIRECT always is. That means the INDEX call would only be
recalculated when some cell in the worksheet changes, but the INDIRECT call
would be recalculated every time Excel recalculated any other cells (in
other worksheets).