本帖最后由 77miya 于 2015-4-16 10:32 编辑
求助个问题。
我做了个表,其中一列是运用函数,下拉后不能自动计算,请问是怎么回事?
函数是: E列:=IF(ISNA(VLOOKUP(D5,Sheet3!A1:D20,2,0)),"",VLOOKUP(D5,Sheet3!A1:D20,2,0));
下拉后依次为:=IF(ISNA(VLOOKUP(D6,Sheet3!A2:D21,2,0)),"",VLOOKUP(D6,Sheet3!A2:D21,2,0));
=IF(ISNA(VLOOKUP(D7,Sheet3!A3:D22,2,0)),"",VLOOKUP(D7,Sheet3!A3:D22,2,0));
............ F列:=IF(ISNA(VLOOKUP(D5,Sheet3!A3:D22,3,0)),"",VLOOKUP(D5,Sheet3!A3:D22,3,0))
下拉后依次为:=IF(ISNA(VLOOKUP(D6,Sheet3!A4:D23,3,0)),"",VLOOKUP(D6,Sheet3!A4:D23,3,0))
=IF(ISNA(VLOOKUP(D7,Sheet3!A5:D24,3,0)),"",VLOOKUP(D7,Sheet3!A5:D24,3,0))
..............
G列:=IF(ISNA(VLOOKUP(D5,Sheet3!A3:D22,4,0)),"",VLOOKUP(D5,Sheet3!A3:D22,4,0))
下拉后依次为:=IF(ISNA(VLOOKUP(D6,Sheet3!A4:D23,4,0)),"",VLOOKUP(D6,Sheet3!A4:D23,4,0))
=IF(ISNA(VLOOKUP(D7,Sheet3!A5:D24,4,0)),"",VLOOKUP(D7,Sheet3!A5:D24,4,0))
............
但是下拉复制公式后,当D列输入信息后,后面的E/F/G列有时不能同时自动计算,有些全部都不能计算,请问是怎么一回事?
模版.rar
(8.51 KB, 下载次数: 1)
2
1
file:///C:\Users\Administrator\AppData\Roaming\Tencent\Users\307078678\QQ\WinTemp\RichOle\N~D7188ZN11L6K}5QV1X1}0.png
|