如何在excel命名范围内引用单元格？ [英] How do I reference a cell within excel named range?

问题描述

E.g。我已经将A10命名为A20作为年龄，现在如何获得与A14相同的Age [5]。

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

我可以写= A14，但我喜欢写=年龄$ 5或某事。

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

推荐答案

您可以使用Excel的索引函数：

You can use Excel's Index function:

=INDEX(Age, 5)

这篇关于如何在excel命名范围内引用单元格？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！