=VLOOKUP(A2&B2,IF({1,0},SHEET1!A$2:A$6&SHEET1!B$2:B$6,SHEET1!C$2:C$6),2,0)在表二的C列输入,然后按ctrl+shift+回车,带出大括号。