Instead of using numbers from 1-52, and assuming the cells are contiguous,
you could use ...COLUMN()-4...
The -4 is actually dependent on which column you begin in, and if your first
data from your vlookup is in column F (aka column 6), then you would subtract
4 (so this would be the 2nd column of your table).

HTH.
--
John C


"Neil" wrote:

I have a spread sheet with a vlookup that i want to return the value of each
colum as i move it across (left to right) by week. how do i get the colum
Ref# to change as i move left to to right, rather than change 52 formulas.
--
Thank you
Neil