本帖最后由 rlz680926 于 2013-6-11 10:50 编辑
=IF(IF(IF(IFERROR(VLOOKUP(A11,$A$1:$B$7,2,),0)=0,IFERROR(VLOOKUP(A11,$C$1:$D$7,2,),0),IFERROR(VLOOKUP(A11,$A$1:$B$7,2,),0))=0,IFERROR(VLOOKUP(A11,$E$1:$F$7,2,),0),IF(IFERROR(VLOOKUP(A11,$A$1:$B$7,2,),0)=0,IFERROR(VLOOKUP(A11,$C$1:$D$7,2,),0),IFERROR(VLOOKUP(A11,$A$1:$B$7,2,),0)))=0,IFERROR(VLOOKUP(A11,$G$1:$H$7,2,),0),IF(IF(IFERROR(VLOOKUP(A11,$A$1:$B$7,2,),0)=0,IFERROR(VLOOKUP(A11,$C$1:$D$7,2,),0),IFERROR(VLOOKUP(A11,$A$1:$B$7,2,),0))=0,IFERROR(VLOOKUP(A11,$E$1:$F$7,2,),0),IF(IFERROR(VLOOKUP(A11,$A$1:$B$7,2,),0)=0,IFERROR(VLOOKUP(A11,$C$1:$D$7,2,),0),IFERROR(VLOOKUP(A11,$A$1:$B$7,2,),0))))
=INDEX(A:H,SUM((A11=$A$1:$G$7)*ROW($1:$7)),SUM((A11=$A$1:$G$7)*{2,3,4,5,6,7,8}))数组公式
=INDEX(A:H,SUM((A11=A$1:G$7)*ROW($1:$7)),SUM((A11=A$1:G$7)*COLUMN(B:H)))数组公式,70多字符
|