Arrrrrrrrrrrrrrrrggggggh! Please help me!!!!

D

D. Hay

If: B2=56; I want want a formula that uses the value of B2 as the row number
for B3. Therefore, the cell address for B3 would be ($A[value of B2]).

I have a huge number of columns from which I need to extract data at
specific points, but those positions change from column to column and sheet
to sheet. Therefore, I need a formula that automatically gives me the value
for the cell address I want using the value in one cell as the row number
for another cell.

I hope that somebody can help me.
Thanks
 
D

D. Hay

Dear JulieD,

Thank you very much. It worked!!!!

However, note to anyone with the same problem as I had, you cannot use a
cell reference in the formula that was derived from a separate formula. In
other words, I had to paste-special "values" and then use those values in my
Indirect formula.

JulieD said:
Hi

try the INDIRECT function
in B3
=INDIRECT("A"&B2)

Cheers
JulieD

D. Hay said:
If: B2=56; I want want a formula that uses the value of B2 as the row
number
for B3. Therefore, the cell address for B3 would be ($A[value of B2]).

I have a huge number of columns from which I need to extract data at
specific points, but those positions change from column to column and
sheet
to sheet. Therefore, I need a formula that automatically gives me the
value
for the cell address I want using the value in one cell as the row number
for another cell.

I hope that somebody can help me.
Thanks
Click to expand...
Click to expand...
 
J

JulieD

Hi

glad it worked & thanks for the feedback .. however, i seem to be able to
use a value derived from a formula (although not extensively tested)

in B2 i have =SUM(B5:B10)
which evaluates to 9
in C2 i have =INDIRECT("A"&B2)
which returns "elephant", ie the contents of cell A9

Cheers
JulieD

D. Hay said:
Dear JulieD,

Thank you very much. It worked!!!!

However, note to anyone with the same problem as I had, you cannot use a
cell reference in the formula that was derived from a separate formula.
In
other words, I had to paste-special "values" and then use those values in
my
Indirect formula.

JulieD said:
Hi

try the INDIRECT function
in B3
=INDIRECT("A"&B2)

Cheers
JulieD

D. Hay said:
If: B2=56; I want want a formula that uses the value of B2 as the row
number
for B3. Therefore, the cell address for B3 would be ($A[value of B2]).

I have a huge number of columns from which I need to extract data at
specific points, but those positions change from column to column and
sheet
to sheet. Therefore, I need a formula that automatically gives me the
value
for the cell address I want using the value in one cell as the row
number
for another cell.

I hope that somebody can help me.
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Top