VBA for vlookup formula

[shiva_reshs]

Hi,

Need vba formula to do the following

1) Sheet(Week1),Range(B13) if IDnumber exist, then in I13 update formula to get the vlookup value from Week2 sheet(A:E,5,0)"

2) This should be done from bottom of last row to up in Sheet(Week1).

Please advise.

Thanks,
Shiva

 

[shiva_reshs]

thanks. I was able to make one. Adding this here for anyone to get info on this.

Sub vlook1()    Dim LastRow As Long
    Dim i As Long
    LastRow = Range("B" & Rows.Count).End(xlUp).Row
    For i = 2 To LastRow
        If Range("B" & i).Value <> "" Then
            Range("I" & i).Value = ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-7],Week2!R10C2:R130C13,7,0)"
        End If
    Next i
End Sub