| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel references within references?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel references within references?
In A100 enter:
=INDIRECT("A" & A1) -- Gary''s Student - gsnu200766 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel references within references?
You want the indirect formula. Something like this...
=indirect("A" & A1) in cell A100 -- HTH... Jim Thomlinson "Mike" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel references within references?
=INDIRECT("A"&A1)
-- David Biddulph "Mike" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel references within references?
On Tue, 29 Jan 2008 09:51:09 -0800, Mike
wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel references within references?
Thanks! it worked
"Gary''s Student" wrote: In A100 enter: =INDIRECT("A" & A1) -- Gary''s Student - gsnu200766 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel references within references?
Thanks it works!
"Jim Thomlinson" wrote: You want the indirect formula. Something like this... =indirect("A" & A1) in cell A100 -- HTH... Jim Thomlinson "Mike" wrote: 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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel references within references?
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. ;-) -- HTH... Jim Thomlinson "Gary''s Student" wrote: In A100 enter: =INDIRECT("A" & A1) -- Gary''s Student - gsnu200766 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel references within references?
thanks
-- Gary''s Student - gsnu200766 "Jim Thomlinson" wrote: 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. ;-) -- HTH... Jim Thomlinson "Gary''s Student" wrote: In A100 enter: =INDIRECT("A" & A1) -- Gary''s Student - gsnu200766 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Excel VBA, dynamic references | Excel Discussion (Misc queries) | |||
| how do i sum if in two different cell references - Excel | Excel Worksheet Functions | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| How do i do 3-D references in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
