Formula with indirect addressing

  • Thread starter Thread starter Erik Mattsson
  • Start date Start date
E

Erik Mattsson

I have a workbook with 4 sheets in. "Total", "2007", "2008" and "2009".
On the "Total" sheet cell

B1 contains "2007" and
B3 contains "='2007'!E3"

I would like to have the formula in cell B3 dynamic in such a way that I
can change the cell B1 to "2008" and by that have the cell B3 show the
value in cell "='2007'!E3".

I have tried different types of "Indirect" by with no luck.

Please tell me how to code this.
 
Hi Erik,

=INDIRECT(B1&"!E3")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a workbook with 4 sheets in. "Total", "2007", "2008" and "2009".
| On the "Total" sheet cell
|
| B1 contains "2007" and
| B3 contains "='2007'!E3"
|
| I would like to have the formula in cell B3 dynamic in such a way that I
| can change the cell B1 to "2008" and by that have the cell B3 show the
| value in cell "='2007'!E3".
|
| I have tried different types of "Indirect" by with no luck.
|
| Please tell me how to code this.
 
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

INDIRECT Syntax 1
Altered pasting functionality 3
Indirect in Conditional Formatting 7
Naming non-contigent cells with vba 5
Search function in Excel 5
Set a Range to a variable 15
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Set non-continuous PrintArea via Function / Name 0

Back
Top