=IF(AND(BM$10=OFFSET(TC!$A$665,ROW()*10-11,,),OFFSET(TC!$E$665,ROW()*10-11,,)="TCå"),OFFSET(TC!$G$665,ROW()*10-11,,),"")
æ
=IF(AND(BM$10=INDIRECT("TC!A"&665+(ROW(A1)-1)*10),INDIRECT("TC!E"&665+(ROW(A1)-1)*10)="TCå"),INDIRECT("TC!G"&665+(ROW(A1)-1)*10),"")
温馨提示:答案为网友推荐,仅供参考