Vlookup Fixed reference but move on colums Ref#
 

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

Vlookup Fixed reference but move on colums Ref#
 

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

Vlookup Fixed reference but move on colums Ref#
 

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

--
Thank you
Neil


"John C" wrote:

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

Vlookup Fixed reference but move on colums Ref#
 

Thanks for the feedback, and don't forget to check the YES box below. :)
--
John C


"Neil" wrote:

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

--
Thank you
Neil


"John C" wrote:

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