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?
Code
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
Display More
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.