Cell Reference in Excel Formula

[whitebread136]

Hi, I'm wondering if anyone knows how to make a formula to reference a cell based on a solution of another problem. For example, could I do something like this.....?[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]-2[/TD]
[TD]-3[/TD]
[TD].11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3[/TD]
[TD]-2[/TD]
[TD].56[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]-1[/TD]
[TD].18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD].96[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]2[/TD]
[TD].33[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]3[/TD]
[TD].85[/TD]
[TD]=if(B6=A2, C6, "")[/TD]
[TD]=if(D6="", "", refer to cell C6 and move (A2-A1, so 5) cells above cell C6) I'm trying to get the number from C1 here now[/TD]
[/TR]
</tbody>[/TABLE]

Hopefully this makes sense.....it would save me a ton of time if someone knew how to do this, thanks.

 

[NeonRedSharpie]

=if(d6="","",index(c:c,row(c6)-(a2-a1)))

Sorry it's lowercase...I can't make it not...

 

[whitebread136]

Thanks, that helped a lot