excel中怎样根据条件调用数据?答:有 在sheet2的D2中输入 =IF(D1=1,Sheet1!A1,IF(D1=2,Sheet1!B1))如果你还想有D1=3,D2=C1…的话,那么就是 =IF(D1=1,Sheet1!A1,IF(D1=2,Sheet1!B1,IF(D1=3,Sheet1!C1,IF(D1=4,Sheet1!D1)))条件有几个,就加几个括号就是了....
Excel 根据条件匹配对应的数据?答:=IFERROR(INDEX(B$1:B$7,SMALL(IF(D$4:D$7>18,ROW(D$4:D$7),4^8),ROW(A1)),),"")=IFERROR(INDEX(D$1:D$7,SMALL(IF(D$4:D$7>18,ROW(D$4:D$7),4^8),ROW(A1)),),"")