CODEWITHSUNDEEP
excel
Abdullah Mamun-Ur- Rashid
Abdullah Mamun-Ur- Rashid

Reputation: 698

How to link a cell to sheet reference

If I type Sheet2!A3 in A1 Cell of Sheet1, it will show the value of A3 cell of Sheet2. But I want to use this reference link from a cell in Sheet1

enter image description here

Please, look at the snapshot. I want to use the C1 cell to get the Sheet2 part of Sheet2!A3. So If I change the value of C1 from Sheet2 to Sheet3, then the formula in A1 will be changed to Sheet3!A3.

How to achieve this?

Upvotes: 0

Views: 106

Answers (2)

Lavanyadav009
Lavanyadav009

Reputation: 130

You can add in another cell to make things simpler

enter image description here

In Sheet2 A3 i have the Value 10

And these formula Get that value with just some simple Indirect reference

enter image description here

If you want to make A3 Dynamic as well then : enter image description here

The Aim is to get a cell which constructs the name of the cell/s you want to reference and then you can indirect Reference them accordingly.

Upvotes: 0

Clusks
Clusks

Reputation: 520

Try: =INDIRECT($C$1&"!A" & ROW() + 2)

This will mean you can have any sheet name in C1, and it should be able to get whatever cell you specify in the quotes (don't forget the exclamation mark!)

EDIT: Sorry, I missed that part, I've updated it now and it should work to increment.

Upvotes: 1

Related Questions