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

chadm · May 3rd, 2002, 05:53 PM

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 · May 3rd, 2002, 05:59 PM

Try the following formula:

=INDIRECT("A" & B5+4)

Aladin Akyurek · May 3rd, 2002, 06:00 PM

=INDIRECT("A"&4+B5)

and,

how about:

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

chadm · May 3rd, 2002, 06:11 PM

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.

May 3rd, 2002, 05:59 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the following formula: =INDIRECT("A" & B5+4) __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 05:53 PM	#1
chadm Join Date: Apr 2002 Posts: 45	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.

May 3rd, 2002, 06:00 PM	#3
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 40,647	=INDIRECT("A"&4+B5) and, how about: =OFFSET($A$1,4+B5-1,0,1,1)

May 3rd, 2002, 06:11 PM	#4
chadm Join Date: Apr 2002 Posts: 45	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.