使用VLOOKUP() [英] Using VLOOKUP()
本文介绍了使用VLOOKUP()的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用Excel的VLOOKUP()第一次,我很难与它。这是截图:
我给单元格B8写了一个公式; = VLOOKUP(C8,$ A $ 2:$ C $ 5,IF(C8 =W,2,3))
$ b $我期待结果1,但是我的结果是错误的0.25。我做错了吗?
感谢您的帮助!
解决方案
你非常接近,vlookup首先使用查询值,所以将第一个C8更改为A8
编辑:正如Barry Houdini在评论中指出的那样,还添加了FALSE作为第四个参数
I am using Excel's VLOOKUP() first time and I am having hard time with it. Here is the screenshot:
I wrote a formula to cell B8; =VLOOKUP(C8, $A$2:$C$5, IF(C8 = "W", 2,3))
I was expecting as a result 1, but I am getting the wrong result 0.25. Am I doing something wrong?
Thanks for the help!
解决方案
you were very close, vlookup takes teh lookup value first, so change the first C8 to A8
EDIT: As Barry Houdini points out in comments, also add FALSE as the fourth parameter
这篇关于使用VLOOKUP()的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文