excel数组公式,如果结果取决于行? [英] excel array formula if result depends on row?
问题描述
似乎我的数组公式的结果取决于行。请参阅附图。单元格 C2
从 $ A的上方单元格的值(
,并尝试返回 s3
)中查找$ 3:$ A $ 11 $ B $ 3:$ B $ 11
中的值(如果匹配)。单元格 D3
, E4
, F5
等。我希望值应该是相同的。但是,我得到错误值
C2
, D3
,和 E4
,以及 M12
和 N13
。我在 F5
, H7
,<$ c> FALSE
$ c> I8 , J9
, L11
。获得有效结果的唯一2个单元格是 G6
和 K10
其中单元格本身与其中的行位于<找到code> s3 。
It seems that the result of my array formula depends on the row. Please see the image attached. Cell C2
looks up from the value of the cell above it (s3
) from $A$3:$A$11
, and tries to return values in $B$3:$B$11
if matched. So are cells D3
, E4
, F5
, etc. I expect the values should be the same. However, I got Error in Value
for C2
, D3
, and E4
, as well as M12
and N13
. I got FALSE
in F5
, H7
, I8
, J9
, and L11
. The only 2 cells that got valid results are G6
and K10
where the cells themselves are on the same row as where s3
is found.
推荐答案
截图中的公式尚未输入数组。如果是的话,它会显示FALSE。该公式没有意义,因为它返回一个数组,而不是单个值。数组不能显示在单元格中,因此只返回数组的第一个值。
The formula in the screenshot has not been array-entered. If it had been, it would show "FALSE". The formula does not make sense, since it returns an array, not a single value. An array cannot be shown in a cell, so only the first value of the array will be returned.
这篇关于excel数组公式,如果结果取决于行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!