address function

  • Thread starter Thread starter flyingmeatball
  • Start date Start date
F

flyingmeatball

I know with the address function I can turn references into text, but is
there a way to do the opposite? In other words, I know I need to
reference cell BX, where X is the value stored in cell C1.
 
I know with the address function I can turn references into text, but is
there a way to do the opposite? In other words, I know I need to
reference cell BX, where X is the value stored in cell C1.
Click to expand...


=INDIRECT("B"&C1)

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
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

Can UDF return a customized hyperlink? 3
use of ADDRESS function within CELL function 4
Variable reference in a function 3
Convert to Excel Macro 3
Set non-continuous PrintArea via Function / Name 0
Convert to Excel Macro 2
logical functions 6
how do I create a cell reference from ADDRESS function return? 3

Back
Top