Hey
I am running this code
For i = 3 To 100
Cells(i, 17).Value = Application.WorksheetFunction.VLookup(Cells(i, 2), Range("B3:D110"), 3)
Next i
the goal is to lookup starting at B3, taking the value in D3 and place it in Q3. Then it should do it for B4 and so on.
The problem is that it does not take the current value for B3, it takes the value for B75 and places it in column Q for all B lookups?
Bookmarks