Vlookup Loop through Lookup value & range

[mhcbackup1]

HI,
i have a file containing 2 tabs . first file contains a list of items extracted from bills of material saved at second tab. I am trying to check where use of each item in the first tab (template) from second tab (Data). But as there is very large number of items in both tabs , its not possible to create a vlookup for each item.
Can anyone suggest a way to loop Lookup value & Range from Vlookup ?
my vlookup formula is
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-5],Data!C[-4]:C[1],6,0)"


Here I want to loop for RC[-5] to next approx 1000 cells
& range as every 7th column to be selected for every loop (eg. for lookup value G1, my range is Data!C:H & so on)


Thanks