Vlookup Fixed reference but move on colums Ref#

[Neil]

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.

 

[John C]

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.

 

[Neil]

John C
Perfect
Thank you so much this saved me a bunch of time.

 

[John C]

Thanks for the feedback, and don't forget to check the YES box below.