Thread: Using variable cell references in Excel? eg A[B42] instead of A7
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GlennC GlennC is offline
external usenet poster
  
Posts: 1
Default 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.
Reply With QuoteReply With Quote