VLOOKUP函数只能满足列A条件的查找,如果我要同时满足列A列B的话应该用...答:在SHEET2的C2输入:=VLOOKUP(A2&B2,IF({1,0},SHEET1!$A$1:$A$100&SHEET1!$B$1:$B$100,SHEET1!$C$1:$C$100),2,)或者 =INDEX(SHEET1!C:C,MATCH(A2&B2,SHEET1!$A$1:$A$100&SHEET1!$B$1:$B$100,),)或者 =OFFSET(SHEET1!$C$1,MATCH(A2&B2,SHEET1!$A$2:$A$100&...