如果Vba中M2以下公式VLOOKUP(B2,$S$2:$T$19,2,FALSE)代码是这样描述If Not Columns("s").Find(Cells(i, 2).Value, lookat:=xlWhole, LookIn:=xlValues) Is Nothing Then MyArr(i - 1, 10) = Columns("s").Find(Cells(i, 2).Value, lookat:=xlWhole, LookIn:=xlValues).Offset(0, 1).Value,哪M2公式如改成=IF(AND(W$2>0,X$2>0),Z2,VLOOKUP(B2,$S$2:$T$19,2,FALSE))又如何表述,谢谢。
本帖最后由 hwc2ycy 于 2012-12-5 18:46 编辑
方法一: - If [w2] > 0 And [x2] > 0 Then
- myarr(i - 1, 10) = [z2]
- Else
- If Not Range("s2:t19").Find(what:=[b2], LookIn:=xlValues, lookat:=xlWhole) Is Nothing Then
- myarr(i - 1, 10) = Range("s2:t19").Find(what:=[b2], LookIn:=xlValues, lookat:=xlWhole).Offset(, 1).Value
- End If
- End If
复制代码
|