载荷- =INDEX(INDIRECT(A2&"!"&CHAR(65+MATCH(E2,INDIRECT(A2 & "!$B$1:$AA$1"),))&1&":"&CHAR(65+MATCH(E2,INDIRECT(A2 & "!$B$1:$AA$1"),))&1000),MATCH(1=1,IF(ISNUMBER(INDIRECT(A2&"!"&CHAR(65+MATCH(E2,INDIRECT(A2 & "!$B$1:$AA$1"),))&1&":"&CHAR(65+MATCH(E2,INDIRECT(A2 & "!$B$1:$AA$1"),))&1000)),INDIRECT(A2&"!"&CHAR(65+MATCH(E2,INDIRECT(A2 & "!$B$1:$AA$1"),))&1&":"&CHAR(65+MATCH(E2,INDIRECT(A2 & "!$B$1:$AA$1"),))&1000),0)>C2,))
复制代码 |