Linking to contents in a cell

[marathonrunner]

I can't for the life of me remember how to link to the contents in the cell and I can't remember the keywords to search for it on google.

I'm using google sheets because I didn't pay for excel so I hope it still works the same.

But I remember I was able to link in sheet 2 to a cell in sheet 1 by the contents of the cell in sheet 2, for example please see image below:

Screen Shot 2021-10-15 at 11.41.39 AM.png

Basically I could use the two cells above that say "sheet 1" "a1" and use those to return whatever is in sheet 1 a1 and then I can copy that formula to the right so I can then get "sheet 1 b1" "sheet 1 c1" etc.

I think I had to use " " and & but I can't remember. Any help would be really appreciated.

[JohnTopley]

Do you mean

in Sheet2

=Sheet1!A1

??

[marathonrunner]

Yes but it would be based on the cells above.

If the cells above said "sheet 1" "c10"

It would link to sheet1c10. If I change "c10" to "z4" it would link to sheet1z4.

If I change from sheet1 to "sheet 3" and "j5" it would link to sheet3j5.

I want to be able to manipulate the above 2 cells to the sheet I want and the cell reference I want.

Instead of using = and clicking on the cell in the sheet. Cause that would make it unchangeable.

[GeoffW283]

Maybe in B3 copied right:

Please Login or Register  to view this content.

[marathonrunner]

Yes thats the one!

[GeoffW283]

Good! Thanks for the feedback and rep! (please mark the thread as solved if you're all set).

[marathonrunner]

Done and done