Function to return cell address

[ChristineJ]

Without using VBA, is there a function that returns the cell address of another cell?

Example: The value in cell O3 is 100. If =O3 is entered in cell O2, 100 will appear. I want O3 to appear in cell O2.

Thanks.

 

[Joe4]

Your example does not make much sense to me.
You want to be able to type =O3 in cell O2 and have it return O3?
Then why not just type O3 in cell O2 instead of =O3?

I have a feeling that maybe you oversimplified this question down to the point where it doesn't make much sense.
Can you prevent a real example of how/why you are trying to do this, exactly as how you are trying to use it (without oversimplifying it)?

 

[Fluff]

You can get the address with either of these functions

=CELL("address",O3)
=ADDRESS(3,15)

but it really depends on what you are trying to do.

 

[Joe4]

You can get the address with either of these functions

=CELL("address",O3)
=ADDRESS(3,15)

but it really depends on what you are trying to do.

I am curious as to the application here, as with those formulas you have to tell it the cell that you want the address of.
If you already know the cell address (which you have to provide), then there doesn't really seem to be any need for a function to return that which you already know.

 

[Fluff]

If you already know the cell address (which you have to provide), then there doesn't really seem to be any need for a function to return that which you already know.

Totally agree, it does seem a bit pointless.

 

[ChristineJ]

You are right that I oversimplified the question, just to avoid a complicated explanation. Sorry I did not give you much to go on.
Thanks to you both. =CELL("address",O3) will work for what I need to do.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Joe4]

Glad that it works for you.
I figured that there probably had to be "more than meets the eye" with this one, and was just trying to understand it in order to try to come up with a workable solution.
I am curious though, about your actual situation and how you are using it, if you wouldn't mind sharing it.