I have one cell, lets say A2, in summary sheet. I want A2 have the value
that is the name of other tabs (other tab named "Scenario 1", "Secnario 2",
"Scenario 3"....). value in A2 will be choosen by user as they can pick
differen scenarios.

In formula in the rest of summary sheet, I want to get values from other
tabs by using A2 to choose which tab to go to. For example, if in cell A2,
it has the name of Scenario 1, then in other formula, can I have somthing
such as A2D4, (meaning D4 cell of Scenario 1 tab) to retrieve the value? I
can't figure out the syntax. Maybe it's not possible?

Use INDIRECT

=INDIRECT("'"&A2&"'!D4")

--

Regards,

Peo Sjoblom

"Trilexist" wrote in message
...
I have one cell, lets say A2, in summary sheet. I want A2 have the value
that is the name of other tabs (other tab named "Scenario 1", "Secnario
2",
"Scenario 3"....). value in A2 will be choosen by user as they can pick
differen scenarios.

In formula in the rest of summary sheet, I want to get values from other
tabs by using A2 to choose which tab to go to. For example, if in cell
A2,
it has the name of Scenario 1, then in other formula, can I have somthing
such as A2D4, (meaning D4 cell of Scenario 1 tab) to retrieve the value?
I
can't figure out the syntax. Maybe it's not possible?