View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kia
 
Posts: n/a
Default VLOOKUP need to increment col_index_num

If I have =VLOOKUP(date,data,2) and in the next cell down I want
=VLOOKUP(date,data,5) so the col_index_num increments by 3 each time how
would I go about doing this so that it can be copied down instead of editing
each line by hand?

Many Thanks in advance