Excel references within references?

  • Thread starter Thread starter Mike
  • Start date Start date
M

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.
 
You want the indirect formula. Something like this...

=indirect("A" & A1)
in cell A100
 
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.
Click to expand...


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



--ron
 
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. ;-)
 
thanks
--
Gary''s Student - gsnu200766


Jim Thomlinson said:
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. ;-)
Click to expand...
 
Back
Top