MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need to use a cell reference AS a cell reference


Posted by Tim on December 13, 2001 12:52 PM

This is complicated, but I have do run hundreds of correlations off of data that starts in differenct rows.

The problem is best illustrated like this. Let's say I have the cells and values:

Cell A1: 5
Cell A2: A
Cell A3: 1

What I want to do is write a formula in cell A4 that returns the value of cell A1 (5), using only Cells A2 and Cell A3. You can see that what is in A2 and A3 is the column and row address of the number that I want.

Is there a way to do this???

Please help. Thanks,
Tim.


Posted by Mark W. on December 13, 2001 12:55 PM

=INDIRECT(A2&A3)

Posted by Aladin Akyurek on December 13, 2001 12:57 PM

Tim,

It's: =INDIRECT(A2&A3)

Aladin