View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati[_2_] Vasant Nanavati[_2_] is offline
external usenet poster
 
Posts: 45
Default How to get the value of a given cell address in excell

Hi:

=INDIRECT(G3)

Regards,

Vasant.

"Nauman" wrote in message
om...
Hi,

It's probable very stupid easy, but I cannot seem to figure it out.

I have three cells. F3,G3,H3

F3 = 23 (number)
G3= $F$3 (as text)

Now, in third cell i want to have a formule that would give me some
thing like following. (Ofcourse it's a psudo code.)

H3= value(G3)=23 or H3=value($F$3)=23 but I cannot pass the
value $F$3 but only the cell address G3.

Any idea?

Thanks in advance for you help.