???Refer to a specifc cell in a named range
 

Just wonderif i name a range, is there a formula that I can refer to a
specific cell in that range

For example , I define cell A1:c10 as "JAPAN"
I would like to create a formla that will return Cell A3 within Japan.

Can I do that ??
--
Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

???Refer to a specifc cell in a named range
 

Hi Jaylin,

To retrieve the value of A3 within Japan you could use
=INDEX(Japan,3,1)
or
=OFFSET(Japan,2,0,1,1)
for example.

HTH,
Bernd