Comment reference a cell avecin excel named range?

[ForumBot]

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.

[ForumBot]

You can use Excel's `Index` function:

```
=INDEX(Age, 5)

```