cell text referring to tab name

T

Trilexist

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?
 

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

Top