How do I reference a cell within excel named range?

Question

For example, I have a named range A10—A20 as Age; 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 similar.

Answer 1

You can use Excel's Index function:

=INDEX(Age, 5)