假設Sheet2嘅B2係人名,H2-O2係能力值,而我想係Sheet1嘅D6到打出人名,Sheet1嘅E6-L6就會自動顯示出佢嘅能力值.請問各位呢個formula係點打呢???
謝謝解答!!!
Excel 問題
2008-09-01 7:04 pm
回答 (2)
2008-09-01 9:38 pm
✔ 最佳答案
Try like this1. Copy the following equation into the cell E6 in sheet 1
=VLOOKUP($D$6,Sheet2!$B:$O,5+COLUMNS($D$6:E6),FALSE)
2. Copy the cell E6 to the cell F6 to L6 in sheet 1
(You are HIGHLY recommended to use "FALSE" in VLOKUP, because some situation will happen bugs when you are using "True" or Default (Miss it))
2008-09-02 09:57:04 補充：
Try like this
=VLOOKUP($D$6,'C:\Documents and Settings\hellokitty\桌面\[Book1.xls]Sheet1'!$B:$O,5+COLUMNS($D$6:E6),FALSE)
2008-09-02 09:59:17 補充：
\ is divider (/)
參考: myself, myself
2008-09-01 9:31 pm
你可以試一下以下的例子
Sheet 2
A
B
C
D
E
F
G
1
劉備
100
90
82
30
85
37
2
關羽
80
99
88
90
45
64
3
張飛
60
99
30
75
25
75
Sheet 1
在B1 - G1輸入公式：
B1 =VLOOKUP(A1,Sheet2!A1:G3,2)
C1 =VLOOKUP(A1,Sheet2!A1:G3,3)
D1 =VLOOKUP(A1,Sheet2!A1:G3,4)
E1 =VLOOKUP(A1,Sheet2!A1:G3,5)
F1 =VLOOKUP(A1,Sheet2!A1:G3,6)
G1 =VLOOKUP(A1,Sheet2!A1:G3,7)
當你在Sheet 1的A1輸入人名時，看看結果吧！
Sheet 2
A
B
C
D
E
F
G
1
劉備
100
90
82
30
85
37
2
關羽
80
99
88
90
45
64
3
張飛
60
99
30
75
25
75
Sheet 1
在B1 - G1輸入公式：
B1 =VLOOKUP(A1,Sheet2!A1:G3,2)
C1 =VLOOKUP(A1,Sheet2!A1:G3,3)
D1 =VLOOKUP(A1,Sheet2!A1:G3,4)
E1 =VLOOKUP(A1,Sheet2!A1:G3,5)
F1 =VLOOKUP(A1,Sheet2!A1:G3,6)
G1 =VLOOKUP(A1,Sheet2!A1:G3,7)
當你在Sheet 1的A1輸入人名時，看看結果吧！
收錄日期: 2021-04-13 16:01:50
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20080901000051KK00436