Using variable cell references in Excel? eg A[B42] instead of A7
 

How would I do the following? Say cell B42 has a 7 in it. So I then want to
reference this element of column A, therefore A7. How would I do it?
Effectively referencing A[B42]. Thanks in advance.

Using variable cell references in Excel? eg A[B42] instead of A7
 

One way:

=INDEX(A:A,B42)


--
Biff
Microsoft Excel MVP


"GlennC" wrote in message
...
How would I do the following? Say cell B42 has a 7 in it. So I then want
to
reference this element of column A, therefore A7. How would I do it?
Effectively referencing A[B42]. Thanks in advance.