Reference tab based off cell value

Copper Contributor

Hello!  Thank you for your help with this.

I have a tab called results.  In that tab, I ask which map to reference (map 1, 2, 3, or 4).  The cell value will be a list of number 1-4.

I then have 4 other tabs labled "Map 1 Data" "Map 2 Data" etc.

Say they choose map 1.  I would like a cell on the results tab to reference a cell (say C1) on "Map 1 Data" tab.  If they choose 2, then I want it to reference the same cell in the "Map 2 Data" tab.

Is there a way to reference these tabs without using nested if's? is there a way to reference 'Map ' (cell value) ' Data'!C1 for example?

1 Reply
I figured it out!

=INDIRECT("'Map "&R2&" Data'!C1")

Thank you for listening to me!