how to obtain the cell?

[jamiguel77]

hi all

easy question (not know how to)

i am on B1

i want write: =getPointCell(A1) and here i want the value "A1"

of cours if i am on C500 and i put: getPointCell(H1011) i want get the value of "H1011"


how to do?

of course getPointCell(A1) <---------------- not exist...


tahnks

 

[JoeMo]

Might be easier to put:
=A1
in cell B1 and,
=H1011
in cell C500

 

[jtakw]

Nevermind...

 

[jamiguel77]

Joemo not aply because if in the Cell A1 you have this value: ELEPHANT then in B1, the value is ELEPHANT i want a string "A1" in the Cell B1

Thanks

 

[jtakw]

Hi,

OK, I'm very confused here, so you want a formula where the function would reference a cell, and the result should be the Cell reference?

So, based on your OP, let's just say such a function Exist =getPointCell(A1), you want the result to be A1, so why not just type A1????.....

If there're some Other underlying requirements and/or criterion that you have not explained, please do so.

 

[jamiguel77]

jtakw

thanks for answer in first place

not i dont want the value of A1 i want the direction "A1"

thanks

 

[mikerickson]

Cells contain numbers, dates, strings or boolean values (or formulas that return numbers, dates, strings or boolean values).

I'm not sure what you mean by "the direction A1" as different than the string "A1".

Perhaps =CELL("address", A1) will do what you want.

 

[jamiguel77]

done!!! thanks this my friend:

=CELL("address", A1)