vba help with vlookup

[steve2115]

Need some help with vba to handle vlookup from one sheet to another in same workbook.
Standard formula in cell U2 to bottom of dart =VLOOKUP($E2,'Ampacet Pricing File'!$C:$F,4,FALSE)
I need to lookup E2,E3,E4, etc. to bottom of data on sheet 'Upload' to sheet 'Ampacet Pricing File' columns C:F, and then bring back the value to sheet 'Upload' column U.

thanks
Steve

 

[Fluff]

Do you want the formula in the cell, or just the value?

 

[DanteAmor]

Try this

Sub test1()
  With Range("U2:U" & Range("E" & Rows.Count).End(xlUp).Row)
    .Formula = "=VLOOKUP($E2,'Ampacet Pricing File'!$C:$F,4,0)"
    .Value = .Value
  End With
End Sub

Remove this line if you only want the formula

 .Value = .Value

 

[steve2115]

Thank you DanteAmor. That worked perfectly!

 

[DanteAmor]

Im glad to help you. Thanks for the feedback.