VLOOKUP给了#N / A,我不知道为什么 [英] VLOOKUP giving #N/A and I have no idea why
问题描述
为什么这个工作吗?我尝试检查空白,确定长度是一样的等等。推动我坚果!我只想要阿拉巴马州!给出的错误是值不可用。
通常的解决方案是应用= MATCH来查找行号数组:
= MATCH(D1,B:B,0)
pre>
将在ColumnB中搜索
D1
中的值(最后一个0
意味着),并希望返回2
(所选数组中的第二行 - 即整个ColumnB)。然后可以将其输入:= INDEX(A:A,MATCH(D1,B:B,0))
它成为ColumnA的第二行,即
阿拉巴马州
此处的详细信息 = MATCH = INDEX 以及 http://www.excelhero.com/ blog / 2011/03 / the-imposing-index.html
Why doesn't this work? I tried checking for whitespace, made sure length was the same, etc. Driving me nuts! I just want Alabama! The error given is "Value not available".
解决方案The usual solution is to apply =MATCH to find the row number in the array:
=MATCH(D1,B:B,0)
will search for the value in
D1
in ColumnB (the last0
means exactly) and hopefully return2
(the second row in the chosen array - ie the whole of ColumnB). This can then be fed into:=INDEX(A:A,MATCH(D1,B:B,0))
where it becomes the second row of ColumnA, ie
Alabama
Details here =MATCH =INDEX and also http://www.excelhero.com/blog/2011/03/the-imposing-index.html
这篇关于VLOOKUP给了#N / A,我不知道为什么的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!