I2输入=LOOKUP(1,0/($A$2:$A$100=$G2)*($B$2:$B$100=$H2),Sheet1!C1:C100)向右向下填充。或I2输入=VLOOKUP($G2&$H2,IF({1,0},$A$1:$A$100&$B$1:$B$100,C$1:C$100),2,0)同时按CTRL+shift+回车结束公式，再把I2向右向下填充。
