第1个回答 2011-09-03
在sheet2的A6中输入=vlookup(B2,sheet1!$A$2:$K$1000,4,0)
B6中输入=vlookup(B2,sheet1!$A$2:$K$1000,5,0)
C6中输入=vlookup(B2,sheet1!$A$2:$K$1000,6,0)
D6中输入=vlookup(B2,sheet1!$A$2:$K$1000,7,0)
A8中输入=vlookup(B2,sheet1!$A$2:$K$1000,8,0)
B8中输入=vlookup(B2,sheet1!$A$2:$K$1000,9,0)
C8中输入=vlookup(B2,sheet1!$A$2:$K$1000,10,0)
第2个回答 2011-09-03
A4输入:
=VLOOKUP($B$1,Sheet1!A:J,2,)
A6输入:
=VLOOKUP($B$1,Sheet1!$A:$J,COLUMN(D1),)
将这个公式粘贴到B6、C6、D6
再粘贴到A8(把最后那个D1改为H8)
将A8粘贴到B8、C8
总分公式为:=sum(A6:D6,A8:C8)