View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neil Neil is offline
external usenet poster
 
Posts: 173
Default 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