Excel references within references?

[Mike]

If I want one cell to display the contents of another cell based on a value
input in a third cell, I am unable to get it done.

If cell A1 is the input cell, and I type in 25, I would like cell A100 to
display the value of cell A25.

Excel will not allow me to key in the follwing formula in Cell A100:
=(A(A1))
I cannot use the value in A1 to determine which row within column a to
extract data for cell A100.

 

[Gary''s Student]

In A100 enter:

=INDIRECT("A" & A1)

 

[Jim Thomlinson]

You want the indirect formula. Something like this...

=indirect("A" & A1)
in cell A100

 

[David Biddulph]

=INDIRECT("A"&A1)

 

[Ron Rosenfeld]

If I want one cell to display the contents of another cell based on a value
input in a third cell, I am unable to get it done.

If cell A1 is the input cell, and I type in 25, I would like cell A100 to
display the value of cell A25.

Excel will not allow me to key in the follwing formula in Cell A100:
=(A(A1))
I cannot use the value in A1 to determine which row within column a to
extract data for cell A100.

=OFFSET(A1,A1-1,0)
=INDEX(A1:A99,A1)
=INDIRECT("a"&A1)



--ron

 

[Mike]

Thanks! it worked

 

[Mike]

Thanks it works!

You want the indirect formula. Something like this...

=indirect("A" & A1)
in cell A100

 

[Jim Thomlinson]

WOW... A lot of people can't wear gold but it looks good on you...
Congratulaions on officially being recognized as someone who has spent way
too much time around here. ;-)

 

[Gary''s Student]

thanks
--
Gary''s Student - gsnu200766

WOW... A lot of people can't wear gold but it looks good on you...
Congratulaions on officially being recognized as someone who has spent way
too much time around here. ;-)