Vlookup Fixed reference but move on colums Ref#

N

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.
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top