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

问题描述

例如，我有一个命名范围 A10—A20 作为 Age；我如何获得与 A14 相同的 Age[5].

For example, I have a named range A10—A20 as Age; how do I get Age[5] which is same as A14.

我可以写=A14"，但我确实喜欢写=Age$5"或类似的东西.

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

推荐答案

可以使用Excel的Index功能:

You can use Excel's Index function:

=INDEX(Age, 5)

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