Vlookup在工作表底部附近返回错误结果 [英] Vlookup returns wrong results near bottom of sheet

问题描述

我有一个这样的表:

我需要在 A栏中查找文本，并找到合适的结果，然后将其放在 B栏中.

I need to look up the text in column A, and find an appropriate result for it, and place that in column B.

所以我创建了一个新的引用列表，它看起来像这样:

So I created a new reference list, and it looks like this:

这是我在 B列

=VLOOKUP(B1, MyList, 2)

乍一看似乎可以，但是一旦我通过了 result5 ，我的代码就只能显示结果"result5".像这样:

It appears to work OK at first, however once I got past result5, my code was only able to show the result "result5". Something like this:

我不知道为什么会这样.我的真实列表更大，有超过13,000行.

I don't know why this is. My true list is larger and has over 13,000 rows.

谢谢

推荐答案

VLOOKUP的默认行为是假定第一列顺序正确并返回最接近的匹配项.添加FALSE作为第四个参数，或对第一列进行排序将解决此问题，具体取决于您是需要完全匹配还是对最接近的匹配感到满意.

The default behaviour of VLOOKUP is to assume that the first column is in order and return the closest match. Adding FALSE as a fourth parameter, or sorting the first column will fix this, depending on whether you need an exact match, or are happy with the closest match.

这篇关于Vlookup在工作表底部附近返回错误结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！