|
查看: 1683|回复: 7
|
请问有人熟悉excel地vlookup??????
[复制链接]
|
|
|
|
请问谁能用vlookup这功能把一个问件从另两个问件里找资料呢???? |
|
|
|
|
|
|
|
|
|
|
|
发表于 31-1-2007 11:25 PM
|
显示全部楼层
|
|
|
|
|
|
|
|
|
|
|
发表于 31-1-2007 11:30 PM
|
显示全部楼层
|
|
|
|
|
|
|
|
|
|
|
发表于 31-1-2007 11:43 PM
|
显示全部楼层
sheet1 sheet2
win1 d1 d1 a
win2 d2 d2 b
win3 d3 d3 c
win4 d4 d4 a
to get sheet2 column 'B' into sheet1 column 'C' by looking up identical value from sheet1 'B' and sheet2 'A'.
首先 highlight sheet2 需要的资料 (a1-b4), name it say 'win'. on sheet1 column c3 key in '=IF(ISNA(VLOOKUP($B1,win,2,FALSE)),0,VLOOKUP($B1,win,2,FALSE)) '
isna to replace 'error' by '0'; win = data u named earlier. '2' = value shown in current field taken from sheet2; $B1 = the value to be compared with first column in 'win'in sheet2.
p/s: chinese input suddenly not functioning.
[ 本帖最后由 friday 于 31-1-2007 11:49 PM 编辑 ] |
|
|
|
|
|
|
|
|
|
|
|
发表于 2-2-2007 04:48 PM
|
显示全部楼层
|
怎样？明白吗？你要的是这样吗？没回答不懂是不是你要的。。。 |
|
|
|
|
|
|
|
|
|
|
|
楼主 |
发表于 2-2-2007 11:35 PM
|
显示全部楼层
|
|
|
|
|
|
|
|
|
|
|
发表于 7-5-2009 09:53 AM
|
显示全部楼层
原帖由 friday 于 31-1-2007 11:43 PM 发表 
sheet1 sheet2
win1 d1 d1 a
win2 d2 d2 b
win3 d3 d3 c
win4 d4 d4 ...
谢谢你，
你的方程式也让我受益了。
 |
|
|
|
|
|
|
|
|
|
|
|
发表于 15-12-2010 12:21 PM
|
显示全部楼层
不客气！
 |
|
|
|
|
|
|
|
|
|
| |
 本周最热论坛帖子
|
变色卡
千斤顶
1623 
53
