Hi all,
This Formula
=IF(B1=0,"",VLOOKUP(D1,Sheet2!$C:$AH,14,FALSE))
is same as below code
For Each cell In Range("U18:U" & Range("D" & Rows.Count).End(xlUp).Row)
If cell.Value < Date And cell.Offset(0, -19).Value = 1 Then
'cell.Offset(0, 0).Formula = "=Vlookup(" & Cells(cell.Row, "D").Address & ",Sheet2!$C:$AH,14,FALSE)"
End If
Next cell
And I would like to need your help to modify the above code to this formula
=IF(B1=0,"",IF(ISNA(I1),"1/1/2009",VLOOKUP(D1,Sheet2!$C:$AH,14,FALSE)))
Regards,
tt3
Bookmarks