Using names

[Alexander_Golinsky]

Hi all, Please hlep!

there is a named range on the worksheet in cell A1- "GiGS"

I want to type "GIGS" in 1st cell and then in 2nd one to write formula "=A1*5". So excel need to understand that in A1 there is a name and not just a string.

Is it possible? Thanks in advance!

[dilipandey]

Okay.. try using =indirect(a1)*5


Regards,
DILIPandey
<click on below * if this helps>

[Alexander_Golinsky]

Unbelivieble! Thank you!!

[dilipandey]

you are welcome Alexander.... cheers


Regards,
DILIPandey
<click on below * if this helps>