Refer current cell in other sheet

[jokr1]

I have two sheets, "SheetA" and "SheetB"

Is it possible in SheetB to refer to the same cell in SheetA with the same code no matter which cell in SheetB you use the code?

What I mean is in cell C4 SheetB not refer to C4 in SheetA by using
=SheetA!C4
but rather by using something like:
=SheetA!(same cell as where the code is in SheetB)

 

[Joe4]

Is it possible in SheetB to refer to the same cell in SheetA with the same code no matter which cell in SheetB you use the code?

Not really clear what you mean by this.
Can you provide an ACTUAL example, telling us exactly what is in the cell that you are trying to match up?
And what are you trying to do with this information once you identify the cell?

 

[jokr1]

I wonder if it is possible to use something like

ADDRESS(ROW(),COLUMN())

to address the same cell in another sheet?

 

[Joe4]

Try this:

=INDIRECT("SheetB!" & ADDRESS(ROW(),COLUMN()))

 

[jokr1]

Thank you, works perfectly!

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[Eric W]

Or a non-volatile version:

=INDEX(SheetB!$1:$1048576,ROW(),COLUMN())