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

Similar Threads

Excel - Wich Function should I use? 1
Consolidation Table from Different Excel Tabs with Different Format 1
Help with an if then scenario 2
Vlookup and return sheet name also 2
Referring to a cell by using another cell for the row number 6
Named Ranges and Dynamic Formulas 4
How do I recalculate cell only if reference cell value changes? 4
Naming of tabs from data in a worksheet 2

Top