Thread: Using variable cell references in Excel? eg A[B42] instead of A7
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default 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.


Reply With QuoteReply With Quote