Thread: Address
View Single Post
  #3   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

Not exactly like you wanted, but:

P.e. you want to display value from cell, referenced by strin in cell A1.
You can do it with formula
=INDIRECT(A1)

Now, when you enter into A1 text "C10", in cell with formula the value from
cell C10 is displayed.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"Grisha Jose" <Grisha wrote in message
...
If I type a formula in a cell " =C10 ". In another cell I must get result

C10.

can any body help me