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

  • Thread starter Thread starter GlennC
  • Start date Start date
G

GlennC

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