使用 VLOOKUP() [英] Using VLOOKUP()

问题描述

我第一次使用 Excel 的 VLOOKUP() 并且我很难使用它.截图如下:

I am using Excel's VLOOKUP() first time and I am having hard time with it. Here is the screenshot:

我在单元格 B8 中写了一个公式；=VLOOKUP(C8, $A$2:$C$5, IF(C8 = "W", 2,3))

I wrote a formula to cell B8; =VLOOKUP(C8, $A$2:$C$5, IF(C8 = "W", 2,3))

我期待的结果是 1，但我得到了错误的结果 0.25.我做错了什么吗?

I was expecting as a result 1, but I am getting the wrong result 0.25. Am I doing something wrong?

感谢您的帮助！

推荐答案

你已经很接近了，vlookup先取了查找值，所以把第一个C8改成A8

you were very close, vlookup takes teh lookup value first, so change the first C8 to A8

正如 Barry Houdini 在评论中指出的那样，还添加 FALSE 作为第四个参数

As Barry Houdini points out in comments, also add FALSE as the fourth parameter

这篇关于使用 VLOOKUP()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！