B
BEEJAY
Greetings:
Excel 2003:
Using example below:
A1 is manually entered - in this case, as +B4
Need a formula in cell A6, that would "go to" the cell referenced in A4,
then select the data from column C, ( 118 ).
In other words, Cell A6 should:
Read cell reference indicated in A4,
Then "go to" B4,
then enter value one column to right.
I'm trying variations of:
=Range("A1").offset(0,1)
A B C
1 4 1 100
2 2 106
3 3 112
4 4 118
5 5 121
6 X
I hope this is clear enough.
Excel 2003:
Using example below:
A1 is manually entered - in this case, as +B4
Need a formula in cell A6, that would "go to" the cell referenced in A4,
then select the data from column C, ( 118 ).
In other words, Cell A6 should:
Read cell reference indicated in A4,
Then "go to" B4,
then enter value one column to right.
I'm trying variations of:
=Range("A1").offset(0,1)
A B C
1 4 1 100
2 2 106
3 3 112
4 4 118
5 5 121
6 X
I hope this is clear enough.