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...
mebkc
Mar 14, 2023Copper Contributor
I figured it out!
=INDIRECT("'Map "&R2&" Data'!C1")
Thank you for listening to me!
=INDIRECT("'Map "&R2&" Data'!C1")
Thank you for listening to me!