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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |