Cell reference manipulation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi
Have a look at the INDIRECT function. Sorry I can't help more but my Excel
is busy recalculating a rather large sheet!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Skip Reference Sequences during copy 3
Column headings display as a numbers 7
Cell Referencing between multiple worksheets 3
Code to format cells on several worksheets 2
Dynamic Cell References in Excel 2
return the reference of a cell with certain text in it 2
Count in a Cell Reference 7
refer to the cell as it is empty... 2

Back
Top