=LOOKUP(1,0/((Sheet1!$A$2:$A$7=Sheet2!A2)*(Sheet1!$B$2:$B$7=Sheet2!B2)),Sheet1!$C$2:$C$7)
在表sheet2的C1单元格中输入公式：=VLOOKUP(A1&B1,IF({1,0},Sheet1!A:A&Sheet1!B:B,Sheet1!C:C),2,0)以Ctrl+Shift+Enter三键结束。下拉。
