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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct formula help (possible Index????) 7
=IF(AND(LOOKUP(F3,A21:A42)=F3,LOOKUP(B4,B21:B42)=B4),(VLOOKUP(B4,B 9
IF Function 5
Help with a formula 4
Excel does not accept text format! 0
Using wild card characters in Find & Replace 6
Solving for variable with a circular reference 6
Recording Macro - Excel makes reference to a specific cell 4

Top