excel中,2个工作表之间,进行横向查找,并引用,怎么办?拜谢答:D2输入或粘贴:=IF(ISERROR(MATCH(A2,Sheet2!$B$3:$M$3,0)),"",INDEX(Sheet2!$B$1:$M$1,MATCH(A2,Sheet2!$B$3:$M$3,0),1))E2输入或粘贴:=IF(ISERROR(MATCH(A2,Sheet2!$B$3:$M$3,0)),"",INDEX(Sheet2!$B$9:$M$9,MATCH(A2,Sheet2!$B$3:$M$3,0),1))下拉...