| 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. |
| 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) | |||
Threaded Mode
