Excel cell value used in formula as row number of address in 2nd cell. 1

[RandySS]

Hi Folks,
Am trying to avoid using VB to accomplish..

What would be the formula in cell #3?

Value in cell #1 is "85" , for example.
Cell #2 is located at Column 10, row 85.
I want formula in cell #3 to return value of cell #2.
Column number in formula in cell #3 would be fixed, I use "10" , above, as a typical. Row number would vary and is based on value of cell #1.

What would be the formula in cell #3?

 

[bluedragon2]

Take a look at the INDIRECT function

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...