EXCEL 中用宏为单元格生成公式答:C2输入=AVERAGE(VLOOKUP(A2,INDIRECT("050"&$A$1&"!A:C"),3,FALSE),VLOOKUP(A2,INDIRECT("050"&A1+1&"!A:C"),3,FALSE),VLOOKUP(A2,INDIRECT("050"&A1+2&"!A:C"),3,FALSE),VLOOKUP(A2,INDIRECT("050"&A1+3&"!A:C"),3,FALSE),VLOOKUP(A2,INDIRECT("050"&A1+4&"...