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.