ExcelBanter - How to get the value of a given cell address in excell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to get the value of a given cell address in excell (https://www.excelbanter.com/excel-programming/275868-re-how-get-value-given-cell-address-excell.html)

Vasant Nanavati[_2_]

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.

All times are GMT +1. The time now is 03:35 AM.