sheet1、2都是数学吗?还是一个是语文一个是数学?如果是后者,用VLOOKUP公式在SHEET3的C2输:=IF(VLOOKUP(C2:C11,Sheet1!B$2:C$8,2,FALSE)>=0,VLOOKUP(C2:C11,Sheet1!B$2:C$8,2,FALSE),"0")D2输:=IF(VLOOKUP(C2:C11,Sheet2!B$2:C$8,2,FALSE)>=0,VLOOKUP(C2:C11,Sheet2!B$2:C$8,2,FALSE),"0")如果是两张都是数学,原理同上,C列改成数学,D列不变,E列改成语文. |