如何从命名范围中查找单元格的值 [英] How to find value of a cell from named range
本文介绍了如何从命名范围中查找单元格的值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在这个命名范围内找到单元格,我知道行的索引
解决方案
只需使用 INDEX
,通常会指定名称而不是范围,例如,如果 YourNamedRange
命名范围 A1:A100
然后
= INDEX(YourNamedRange,IndexNumber)
和
= INDEX(A1:A100,IndexNumber)
相当于
Is in EXCEL some formala, that can find value of a cell. Something like INDEX, but instead of an index column, a named range.
I want to find cell in this named range and i know index of row
解决方案
Just use INDEX
as would would normally, and specifiy the name rather than the range, eg if YourNamedRange
names the range A1:A100
then
=INDEX(YourNamedRange, IndexNumber)
and
=INDEX(A1:A100, IndexNumber)
are equivalent
这篇关于如何从命名范围中查找单元格的值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文