How do I reference a cell within excel named range ?

Question

E.g. I have named A10 to A20 as Age, now how do I get Age[5] which is same as A14.

I can write "=A14" but I did like to write "=Age$5" or something.

Answer 1

You can use Excel's Index function:

=INDEX(Age, 5)