Display a cell address

[sam]

Good morning –

No amount of post searching turned up my answer, believe it or not.

I have a two-tab workbook. Tab one serves as a Table of Contents for
different locations on Tab 2.

On Tab 1, in one cell, I want to have text, and a specific cell address of
Tab 2.

Tab 1 example of the resulting display:

Calendar 2005 - Tab 2, D8

A couple of points.

1. D8 will move around on Tab 2, so the Tab 1 formula will have to “trackâ€
it.
2. If possible, I don’t necessarily want to display Tab 2 in the result,
just the cell
address.

I tried syntax along the lines of ="Calendar 2005 - "&ADDRESS(blah, blah),
but I just can’t make this go…

I’m stumped. Any takers?

Thanks to anyone who takes the time to respond. I’ll keep an eye on the post.

Sam

 

[JE McGimpsey]

One way:

Name your cell, say "cell1"

then use: ADDRESS(ROW(cell1),COLUMN(cell1),4,TRUE)

 

[sam]

Saaweet! Worked like a champ. I would have NEVER figured this out. The ROW
and COLUMN inside ADDRESS totally threw me.

You the man JE M.

Much thx,

Sam