如果列F在单元格中没有任何值,我希望列AX执行VLOOKUP。如果是这样,我希望它显示嵌套的If语句中的内容。
对象定义错误
With .Range("AX2")
.Formula = "=IF(F2="""",VLOOKUP(A2,[PS_Export.xlsx]ps!$A:$AG,33,FALSE),IF(AR176<=300000,AR176*0.3,IF(AND(AR176>300000,AR176<=500000),((AR176-300000)*0.35)+90000,IF(AND(AR176>500000,AR176<=1000000),((AR176-500000)*0.4)+160000,IF(AR176>1000000,((AR176-1000000)*0.45)+360000,))))))"
.AutoFill Destination:=Range("AX2:AX" & lastrow)
End With
发布于 2018-06-06 03:41:09
答:AG只有33列,而不是34列。尝试更改为33或范围更改为A:啊,
With .Range("AX2:AX" & lastrow)
.Formula = "=IF(F2=text(,), VLOOKUP(A2,$A:$AG, 33, FALSE), IF(AR176<=300000, AR176*0.3, IF(AR176<=500000, (AR176-300000)*0.35+90000, IF(AR176<=1000000, (AR176-500000)*0.4+160000, (AR176-1000000)*0.45+360000))))"
End With
https://stackoverflow.com/questions/50707690
复制相似问题