/ Published in: Visual Basic
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
Dim t as Long If Application.IsNA(Application.VLookup(item, rng1, 10, 0)) Then t = 0 Else t = ActiveCell.Offset(0, 51).Value End If # use t instead of the cell value in the following calculation