第1个回答 2014-07-21
b3=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,2,0),"")
e3=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,3,0),"")
h3=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,4,0),"")
c4=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,5,0),"")
h4=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,6,0),"")
c5=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,7,0),"")
h5=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,8,0),"")
c6=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,9,0),"")
h6=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),VLOOKUP(sheet1!$A$1,sheet1!$A$3:$H$1000,10,0),"")
d9=IF(COUNTIF(sheet1!$A$3:$A$1000,sheet1!$A$1),h4&"-"&c5,"")