Forum Discussion
mebkc
Mar 13, 2023Copper Contributor
Reference tab based off cell value
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?
- mebkcCopper ContributorI figured it out!
=INDIRECT("'Map "&R2&" Data'!C1")
Thank you for listening to me!