how to use loop to go down a range

[vranjit138]

Hi Gurus

I need a simple loop that can march through range and give result in another column


Col A has invoice numbers
Col B has Amounts

in Col D from (D1:D456) i have some invoice numbers
in col E how would i populate the amounts for each row using the vlookup function using For Each ...Next Loop in vba

Please tell

Regards
Ranjit

 

[ravishankar]

Hi

x= cells(rows.count,1).end(xlUp).row
y= cells(rows.count,4).end(xlUp).row
b = "A1:B" & x
for a = 1 to y
cells(a,5) = application.worksheetfunction.vlookup(cells(a,4),range(b),2,false)
next a

if you encounter problems, you can subsitute line 4 with
cells(a,5) = "=vlookup(D" & a & ", A1:B" & x & ", 2,false)"
Ravi