|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 1st, 2005, 05:03 PM
|
|||
|
|||
Cell reference manipulation
Is there a way to use a formula to dictate a cell reference?
eg. if cell A1=2 then =B(A1) would reference cell B2? I saw someone else with a similiar question, but saw no posted answer. I suspect it may be possible in R1C1 cell reference mode. 
|
|
#2
April 1st, 2005, 05:09 PM
|
|||
|
|||
|
Use
=INDIRECT("B"&A1) Duke "RwenglerMN" wrote: Is there a way to use a formula to dictate a cell reference? eg. if cell A1=2 then =B(A1) would reference cell B2? I saw someone else with a similiar question, but saw no posted answer. I suspect it may be possible in R1C1 cell reference mode.
|
|
#3
April 1st, 2005, 05:13 PM
|
|||
|
|||
|
Hi
Have a look at the INDIRECT function. Sorry I can't help more but my Excel is busy recalculating a rather large sheet! -- Andy. "RwenglerMN" wrote in message ... Is there a way to use a formula to dictate a cell reference? eg. if cell A1=2 then =B(A1) would reference cell B2? I saw someone else with a similiar question, but saw no posted answer. I suspect it may be possible in R1C1 cell reference mode.
|
|
#4
April 1st, 2005, 09:51 PM
|
|||
|
|||
|
Yup. there are few ways to do it, depends really on what you are trying to
do. The INDIRECT function will do it, or, if you are trying to generate a "moving track" then a litle HLOOKUP will do it. "RwenglerMN" wrote in message ... Is there a way to use a formula to dictate a cell reference? eg. if cell A1=2 then =B(A1) would reference cell B2? I saw someone else with a similiar question, but saw no posted answer. I suspect it may be possible in R1C1 cell reference mode.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using a Text / Data output as a cell reference | Jimboski | General Discussion | 1 | February 11th, 2005 07:31 PM |
| IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
| formula reference in cell | wammer | Worksheet Functions | 1 | August 2nd, 2004 06:39 PM |
| Cut and paste without altering cell reference | ski-rdu | Worksheet Functions | 2 | June 16th, 2004 12:18 PM |
| Circular Reference | John | Worksheet Functions | 2 | January 10th, 2004 07:17 PM |
Linear Mode
