cell text referring to tab name

G

Guest

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

Similar Threads

Reference the same cell based on tab name 1
Vlookup and return sheet name also 2
Named Ranges and Dynamic Formulas 3
Referring to a cell by using another cell for the row number 6
How do I recalculate cell only if reference cell value changes? 4
Sum formula across multiple tabs and fields 2
Dynamic reference to another tab name 5
Using two Vlookup in one Cell 1

Top