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

[Guest]

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 ??

 

[bplumhoff]

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