=LOOKUP(1,0/((Sheet2!$A$2:$A$12=A2)*(Sheet2!$B$2:$B$12=B2)),Sheet2!$C$2:$C$12)用这个公式，试试看{=VLOOKUP(A2 &B2,IF({1,0},Sheet2!$A$2:$A$12 &Sheet2!$B$2:$B$12,Sheet2!$C$2:$C$12),2,FALSE)}
