I need help with making vlookup go all the way across my columns and down. Is it possible to have lookup_value and column_index both be variable values? If it isn't possible, is there another way this can be done?
For Each ws In Worksheets If ws.Name = "Sheet1" Then GoTo JeffRocks3 ws.Select C = 14 For C = 14 To 13 + SNum Cells(7, C).Formula = "=VLOOKUP(C7,Sheet1!$A$2:$BB$3000,Match(N5,Sheet1!$D$1:$BB$1,FALSE)+3,False)" Next C Range("A1").Select JeffRocks3: 'Sheet 1 is Skipped Next ws Sheets("1").Select
As of right now, I got the vlook up to go across, but the the cell value stays the same all the way across, I would need it to change going from one column to another, if this makes sense.
[Blocked Image: http://www.zuko.org/uploader/./userfiles/zuko/gibson.jpg]