Home » Forums » Open Source Learning Center » Question and Answer

vlookup with variables

Submitted by amart47 on 26 September, 2014 - 02:25

new to vba and trying to get a vlookup to run through a list. can anyone help with this code?

Dim i As Integer
dim y as inte
For i = 1 To 300
Worksheets("sheet4").Activate

Range(i, 1).Value = Application.WorksheetFunction.Lookup(Worksheets("sheet3").Cells(i, 2), Worksheets("Sheet2").Range("a1:z400"), 3)

End

Next

end sub

‹ Please Help Me !!! Code to insert data from list between two rows ›
»

Hello Amar. Can u please

Submitted by sravanmonty on 9 October, 2014 - 21:00.

Hello Amar.
Can u please attatch file..to provide solution. ..Thankyou

»