在Sheet1的G3单元格输入以下公式,然后向下填充公式=LOOKUP(1,0/((Sheet2!B$3:B$12=B3)*(Sheet2!C$3:C$12=C3)*(Sheet2!D$3:D$12=D3)*(Sheet2!E$3:E$12=E3)*(Sheet2!F$3:F$12=F3)),Sheet2!A$3:A$12)