Help! I need HELP! How to reference a cell with a formula

[chadm]

Say a column cell contains B5 contains a value

In C6 I want to put in a formula the goes to cell A(B5 + 4).

For example, if B5 contained the value 7, I want C6 to get the value in A(7+4) or A11.

Is there any easy way to do this? EASY = without a Macro.

 

[Al Chara]

Try the following formula:

=INDIRECT("A" & B5+4)

 

[Aladin Akyurek]

=INDIRECT("A"&4+B5)

and,

how about:

=OFFSET($A$1,4+B5-1,0,1,1)

 

[chadm]

SUMIF('Master Illustration'!$D$12:$D$55,">0")

ok, that seems to work, but say the cell reference I want to change is $d$55 - I want it to be D(11 plus the value in B5).

Currently b5 is 44 so D(11 plus 44) is D55.

I have a huge sheet that I have to manually make this change currently.