using text as a cell ref

C

CC-Khriz

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
 
R

Richard Buttrey

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
Click to expand...

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
__________________________
 
H

Harlan Grove

Try one of these:

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

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).
 
Top